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

From: edwin devadanam <edwin_kodamala_at_yahoo.com>
Date: Mon, 23 Oct 2006 10:46:31 -0700 (PDT)
Message-ID: <20061023174631.12818.qmail@web52304.mail.yahoo.com>

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.                                  

---

Do you Yahoo!?
 Next-gen email? Have it all with the all-new Yahoo! Mail.
--

http://www.freelists.org/webpage/oracle-l Received on Mon Oct 23 2006 - 12:46:31 CDT