Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to find out the current time zone in Oracle?

How to find out the current time zone in Oracle?

From: Benoit Losier <blosier_at_shareline.com>
Date: Fri, 31 Aug 2001 11:58:57 GMT
Message-ID: <3B8F7C00.F465EFC9@shareline.com>


I need to convert my date to GMT time using the NEW_TIME function but can't seem to find a way to get the current database time zone.

Our development site has a different time zone then our live sites so I can't hard code the time zone in my script. Received on Fri Aug 31 2001 - 06:58:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US