Re: How set the database timezone to an offset instead of a named timezone(TSLTZ and TSTZ)

Hey

sessiontimezone is your CLIENT
dbtimezone is the DATABASE SERVER

I'll check up on your other question, there's a function that'll do it - meantime, check the sql reference, they're all in there.

Stef

On 10/23/06, edwin devadanam <edwin_kodamala_at_yahoo.com> wrote:
>
> Hi Stefan/All,
>
> What does this output means???(9206DB on apps instance)
>
> SQL> SELECT SESSIONTIMEZONE FROM DUAL;
> SESSIONTIMEZONE
>
> ---------------------------------------------------------------------------
> -04:00
>
> SQL> SELECT DBTIMEZONE FROM DUAL;
> DBTIME
> ------
> +00:00
>
>
> 1)how to convert NAMED timezones to offsets???
>
> Examples of this are the usage of timestamps such as "28-MAR-2006 14:00:00
> Australia/Canberra",
>
>
> Thanks,
> Edwin.K
>
>
> *Stefan Knecht <knecht.stefan_at_gmail.com>* wrote:
>
> sys_at_TP> r
> 1* select * from sys.props$ where name = 'DBTIMEZONE'
>
> NAME VALUE$ COMMENT$
> ------------------------------ ------------------------------
> --------------------------------------------------
> DBTIMEZONE +02:00 DB time zone
>
>
> And you can use alter database to set it to your likes.
>
>
> sys_at_TP> alter database set time_zone='-05:00';
>
> Database altered.
>
>
> Stefan
>
> On 10/20/06, edwin devadanam <edwin_kodamala_at_yahoo.com> wrote:
> >
> > Hi ,
> >
> > 1) How to implement database timezone to an OFFSET instead of NAMED
> > timezone.
> > 2)How to check what database is using either OFFSET or NAMED timezone.
> >
> > Any help would be appreciated.
> >
> >
> > Thanks,
> > Edwin.K
> > ------------------------------
> > Want to be your own boss? Learn how on Yahoo! Small Business.
> > <http://us.rd.yahoo.com/evt=41244/*http://smallbusiness.yahoo.com/r-index>
> >
>
>
> ------------------------------
> Do you Yahoo!?
> Next-gen email? Have it all with the all-new Yahoo! Mail.<http://us.rd.yahoo.com/evt=40788/*http://advision.webevents.yahoo.com/handraisers>
>
>

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