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!