You can translate the question and the replies:

DATE fields being converted to TIMESTAMP in Denodo.

While creating base views from data source (oracle), denodo converts all DATE fields to TIMESTAMP. When we try to access these date fields from any JDBC client in our case 'DBeaver' we get these fields as TIMESTAMP and not 'DATE' fields. Is there a way we can provide TIMESTAMP fields as DATE to end user? Appreciate your help.
user
23-01-2020 13:50:00 -0500

2 Answers

Hi, The Denodo Platform offers the built in function “[CAST](https://community.denodo.com/docs/html/browse/latest/vdp/vql/appendix/syntax_of_condition_functions/type_conversion_functions#cast)” to change the variable type of a column to a different type. To convert back to the “DATE” type for consuming applications, I created a selection view from a base view with “TIMESTAMP” columns and cast the “TIMESTAMP” variable type to “LOCALDATE”. When I accessed the selection view in DBeaver, these columns showed up as “DATE”. For more information about date data types in Denodo you can read the [Data Types for Dates, Timestamps and Intervals](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/language_for_defining_and_processing_data_vql/data_types/data_types_for_dates_timestamps_and_intervals) section of the Denodo Platform 7.0 User Manual. The article also shows the corresponding SQL data type for each of the Denodo data types. I hope this helps!
Denodo Team
24-01-2020 08:58:49 -0500
Thanks for the answer.
user
24-01-2020 15:28:35 -0500
You must sign in to add an answer. If you do not have an account, you can register here