Re: Unix TZ

On 10/25/06, Stefan Knecht <knecht.stefan_at_gmail.com> 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

--
http://www.freelists.org/webpage/oracle-l