How to find time offset from timezone information in Oracle

From: Aparna <Aparna.Nar_at_gmail.com>
Date: Mon, 14 Jan 2008 10:00:48 -0800 (PST)
Message-ID: <1e269de2-113c-4d2d-9e0e-4dec371e8278@e4g2000hsg.googlegroups.com>

I use the below query to get the Timeoffset from a given timezone. However this query will not work for many timezone example for MST.

SELECT TZ_OFFSET('PST') FROM dual; -- this query works fine for Timezone PST and returns a timeoffset correctly
SELECT TZ_OFFSET('SST') FROM dual; --this query does not work for Timezone SST ORA-01882: timezone region not found

How I can I get the timeoffset for all timezones ? Kindly help , this has to be implemented asap!
Any input is appreciated!

regards,
Aparna Received on Mon Jan 14 2008 - 12:00:48 CST

This message: [ Message body ]
Next message: joel garry: "Re: Bigger blocksize on index TBS"
Previous message: csn: "Re: Go To Database Home Page"
Next in thread: Gunter Herrmann: "Re: How to find time offset from timezone information in Oracle"
Reply: Gunter Herrmann: "Re: How to find time offset from timezone information in Oracle"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message