Skip to Content
0
Apr 21, 2014 at 05:08 PM

Dynamically Change TimeZone that incorporates Daylight savings time: EST<->EDT

288 Views

BO Auditing (4.0) saves time in GMT timezone. I created a new dimension in IDT to convert GMT into US Eastern Time.

New_Time(time, ‘GMT’, ‘EST’)

This worked fine until the daylight savings time kicked in on March 8. Starting March 9, my time is an hour behind.

Using ‘EDT’ in the above statement gives the right time during summer.

New_Time(time, ‘GMT’, ‘EDT’)

EDT(Eastern Daylight Time) November 3 – March 8

EST(eastern standard time) rest of the year

My question: Is there a way to dynamically change the time zone that incorporates day light savings time.

Environment: BO4.0., Auditor db: Oracle.

Thank you.