Re: How set the database timezone to an offset instead of a named timezone(TSLTZ and TSTZ)
- From: "Stefan Knecht" <knecht.stefan@xxxxxxxxx>
- To: edwin_kodamala@xxxxxxxxx
- Date: Fri, 20 Oct 2006 11:25:46 +0200
sys@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@TP> alter database set time_zone='-05:00';
Database altered.
Stefan
On 10/20/06, edwin devadanam <edwin_kodamala@xxxxxxxxx> 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>
Other related posts:
