Hi,
The Daylight Saving time is automatically applied based on the i18n configured for your source and base view. If you execute the query in the **Virtual DataPort Admin Tool**, the results will depend on the** i18n** configured for the **Admin Tool**. Similarly, when you execute the query in **VQL shell**, it depends on the i18n configured for the Virtual DataPort **Server**. Therefore, when I execute the below query in the VQL shell with Server i18n as "us_cst"
> Select to_timestamptz('dd-MMM-yyyy HH:mm:ss', '01-Nov-2009 01:59:00', true) from dual();
I was able to get expected result(i.e., 2009-11-01 01:59:00.000-05:00). Therefore, for your scenario, I would check the i18n is configured correctly for that view.
I’d also recommend you to read [Internationalization configuration and dates](https://community.denodo.com/kb/view/document/Internationalization%20configuration%20and%20dates?category=Common+Errors) in our Knowledge Base. I find it very useful to understand how Denodo manages the dates.
Also, if you have a valid support account, I would suggest raising a support case on the [Support Site](https://support.denodo.com/) for more detailed help with the issue.
Hope this helps!
