timestamp_to_string('%d-%m-%Y %H:%M:%E4S', 'EST') Is One hour behind from actual EST time

[Chavya Khanna]

Hello All,

The issue i am experiencing is this particular function timestamp_to_string('%d-%m-%Y %H:%M:%E4S', 'EST') - returns one hour behind after conversion to EST. so if the transaction time was 3 PM it would convert it to 2 PM.

Has anyone experienced this before? Not sure if Daylights saving is working properly as a part of this function.

Hope to get some assistance on this.

Regards,

Chavya Khanna

[Igor Peshansky]

Merging threads. "EST" means "UTC-05:00", while "EDT" means "UTC-04:00" (https://en.wikipedia.org/wiki/Eastern_Time_Zone).

        Igor

--
© 2021 Google Inc. 1600 Amphitheatre Parkway, Mountain View, CA 94043
 
Email preferences: You received this email because you signed up for the Google Stackdriver Discussion Google Group (google-stackdr...@googlegroups.com) to participate in discussions with other members of the GoogleStackdriver community.
---
You received this message because you are subscribed to the Google Groups "Google Stackdriver Discussion Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-stackdriver-d...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-stackdriver-discussion/5af01402-286c-473d-a173-520568d6f00dn%40googlegroups.com.

[Chavya Khanna]

Thanks Igor,

Reading the information you've suggested - does this mean every time there's a change in time , I'll have to make changes in my query too? as i intend to make a Dashboard using this query Or is there any permanent way so that MQL will detect automatically the change in time?

• Eastern Standard Time (EST), when observing standard time (autumn/winter), are five hours behind Coordinated Universal Time (UTC−05:00).
• Eastern Daylight Time (EDT), when observing daylight saving time (spring/summer), are four hours behind Coordinated Universal Time (UTC−04:00).

Regards

Chavya Khanna

[Chavya Khanna]

Thanks alot Igor,

Figured out what to use, so it seems when i tried EDT - it gave me an error message - interestingly we do have an option of choosing 'America/Toronto' (That's where i am located) so this solved the problem.

Thanks a lot!

On Monday, May 16, 2022 at 5:11:22 PM UTC-4 ig...@google.com wrote:

[Igor Peshansky]

Right, that parameter supports values from the IANA Time Zone Database (https://en.wikipedia.org/wiki/List_of_tz_database_time_zones). It looks like regional zone names are the ticket here. Glad you got it working.

        Igor

To view this discussion on the web visit https://groups.google.com/d/msgid/google-stackdriver-discussion/417a05dd-dfe6-44d7-9867-f6317ffe1575n%40googlegroups.com.