Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

convert GMT to EDT/EST

user12057782Mar 12 2012 — edited Mar 12 2012

I want to convert the time from GMT to EDT/EST irrespective of day light savings.

select new_time (to_date ('2003/11/01 01:45', 'yyyy/mm/dd HH24:MI'), 'GMT', 'EST') from dual

10/31/2003 8:45:00 PM

select new_time (to_date ('2003/11/01 01:45', 'yyyy/mm/dd HH24:MI'), 'GMT', 'EDT') from dual

10/31/2003 9:45:00 PM

In above queries manually i changed it from EST to EDT.Is there a way in sql to convert EST to EDT depening on day light saving time?

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 9 2012

Added on Mar 12 2012

#general-database-discussions, #sql

2 comments

1,968 views