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!

How to convert the SYSDATE in local time zone to GMT time zone

488620Feb 7 2006 — edited Feb 7 2006

Hi,
In the database I am working on,the date fields are stored in GMT format.
The time zone of the database is set to local time zone.
So whenever I need to get the active records I need to get the sysdate corresponding to the local time zone,convert it into GMT format and then compare it with the date field in the tables to get the active records.

I want to know whether there is any conversion function to get the date in the GMT from the local time zone?

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 7 2006

Added on Feb 7 2006

2 comments

2,658 views