Skip to Main Content

SQL & PL/SQL

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!

EST to GMT/UTC

539506May 13 2010 — edited May 13 2010
I need to convert a field called CALL_TIMSTAMP from Eastern Standard Time to MM/DD/YYYY HH24:MM:SS in GMT or UTC.

I was wondering if there is a snippet of code out there, perhaps with a case statement, which identifies whether or not the date is of the current/past year's daylight savings time and takes that into account when pulling the data.

Edited by: Morrison on May 13, 2010 10:19 PM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 10 2010
Added on May 13 2010
2 comments
988 views