Skip to Main Content
Forums

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!

Convert EST to GMT

508998Mar 26 2012 — edited Mar 27 2012
Hi All,

Oracle version is 10.2.0.3
In my DB many tables with data date type column. But it has EST TIME ZONE DATA, but the customer what to change the EST time data to GMT.
I have used new_time function but it is not working for daylight saving data .
Please put your valuable thoughts to resolve this issue.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 24 2012
Added on Mar 26 2012
2 comments
261 views