You can translate the question and the replies:

Time zone differences and daylight savings

I need to account for Daylight Saving Time with the data I am processing. One of the rows has a date time of '01-Nov-2009 01:59:00'. When I set the Locale value to us_cst: English (United States) via the Denodo Administration/Admin Tools Preferences option, and I run the following function to_timestamptz('dd-MMM-yyyy HH:mm:ss', '01-Nov-2009 01:59:00', true), it returns 2009-11-01 01:59:00.000-06:00. The returned value for Central Standard Time Zone should have been 2009-11-01 01:59:00.000-05:00, because Daylight Saving Time does not occur until 2:00 AM CST. Please advise.
User
14-10-2020 22:53:04 -0400

1 Answer

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!
Denodo Team
16-10-2020 05:30:41 -0400
You must sign in to add an answer. If you do not have an account, you can register here