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!

How to convert GMT to EST/EDT?

259321Jun 20 2008 — edited Nov 22 2012

Hi,
I want to convert a specific time from GMT to EST or EDT depending on day light saving time.

I want to know whether i can use NEW_TIME(sysdate,'GMT','EST') always irrespective of the day of the year or do i have to change 3rd arugment from EST to EDT depending on the day of the year.

Is NEW_TIME intelligent enough to handle the third argument if i always mention EST? Please advice.

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 20 2012

Added on Jun 20 2008

#general-database-discussions

6 comments

6,976 views