Hi,
To get only the date value from the text field type which contains the value of timestamp with time zone, I would use the** to_localdate** function to convert the text value into a date.
For example, if I need to retrieve only the date value from "2019-12-21T13:15:49.000-0600" text value, then I would use the below similar query,
`Select to_localdate('yyyy-MM-dd''T''HH:mm:ss.SSSSX', '2019-12-21T13:15:49.000-0600') from dual();`
If you need to retrieve the only date value from the field type timestamp, then you could use the **Cast** function to converts data from one data type to another as similar below,
> Cast('localdate', '2019-12-21T13:15:49.000-0600')
For more information, you could refer to the below section of the
* [TO_LOCALDATE](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/appendix/syntax_of_condition_functions/date_processing_functions#to-localdate).
* [Date and time Java patterns](https://docs.oracle.com/javase/7/docs/api/index.html?java/text/SimpleDateFormat.html).
* [Cast](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/appendix/syntax_of_condition_functions/type_conversion_functions#cast).
Hope this helps!