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

From: Gunter Herrmann <>
Date: Mon, 14 Jan 2008 14:43:42 -0500
Message-ID: <478bbb6e$0$27211$>

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



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

Original text of this message