Hi team, I have view sourced from oracle, which contains date type column, when created this view, denodo converted the date column to "timestamp" automatically, and when tried to convert it to "localdate", the error is showing "the field has an incompatible subtype for type 'localdate', TIMESTAMP".
I found the "timestamp" type in denodo make the date column show several succeeding 0s like "2020-07-08 00:00:00", can we make it shown as a date with value "2020-07-08". How to make it?
Also, we need to pushed down all the denodo query to oracle data soruce, currently it is this, and I don't want to this date format convertion make the query not push down to the data source.