I would switch to localdate type in Denodo rather than the date type because the data type has been depreciated. For doing this conversion, I would use the TO_LOCALDATE() function. In this example, I would do the conversion section of the query like this: TO_LOCALDATE('MMM dd, yyyy HH:mm:ss', 'Jun 29, 2005 19:19:41'). For more information, please follow the [Datetime Functions](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/functions/datetime_functions/datetime_functions) section in the Virtual DataPort VQL Guide for clarification on the functions that are available.
Hope this helps!