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

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>
>
>

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