On 10/25/06, Stefan Knecht <knecht.stefan@xxxxxxxxx> wrote:
Time zone is set during database creation - so it's gotta be stored somewhere inside the data dictionary. question would be: if it's not set explicity during database creation, and oracle uses the os value, if that os value gets altered between instance startup and shutdown, wether or not oracle will use the new value, or stick to the one that was set when creating the database.
check database_properties for the current value
Some clues:
Check out to_timestamp_tz, cast, tz_offset and date formats all in the SQL reference.
There are functions to easily find the offset in hours from UTC, but they don't return the named zone.
select tz_offset(sessiontimezone) from dual;
select tz_offset(dbtimezone) from dual;
Googling for 'determine oracle tz' turned up some prospects.
Jared
-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist