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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Unix TZ

Re: Unix TZ

From: Jared Still <jkstill_at_gmail.com>
Date: Thu, 26 Oct 2006 09:59:58 -0700
Message-ID: <bf46380610260959h3f71a706v8d3e9dd8666d1f30@mail.gmail.com>


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
Received on Thu Oct 26 2006 - 11:59:58 CDT

Original text of this message

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