Can a Package determine db's time zone during exec?

From: Dave Podnar <dave.podnar_at_daytonOH.ATTGIS.COM>
Date: 1995/07/10
Message-ID: <DBIpKr.6pC_at_corsair.daytonoh.attgis.com>#1/1


I am looking for assistance with identifying a database's time zone. I cannot find any info (PL/SQL, functions, etc.) on how to determine the time zone (EST, EDT, etc.) of the local database (CHI) during package execution.

I know there was a recent thread about storing all times in GMT but I didn't see anything mentioned about getting the databases time zone.

All suggestions are greatly appreciated.

dave.podnar_at_daytonOH.ATTGIS.COM
"You can keep living in the nile, Grace." -- Jimmie Received on Mon Jul 10 1995 - 00:00:00 CEST

Original text of this message