Re: How to find time offset from timezone information in Oracle

Aparna wrote:
> 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.
>
> 1. SELECT TZ_OFFSET('PST') FROM dual; -- this query works fine for
> Timezone PST and returns a timeoffset correctly
>
> 2. SELECT TZ_OFFSET('SST') FROM dual; --this query does not work for
> Timezone SST
> ORA-01882: timezone region not found

SELECT * from V$TIMEZONE_NAMES

brgds

Gunter Herrmann in Orlando Received on Mon Jan 14 2008 - 13:43:42 CST