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

From: Aparna <>
Date: Mon, 14 Jan 2008 12:16:21 -0800 (PST)
Message-ID: <>

Hello Guntur,

   Thanks for the response.

I am aware that for oracle function TZ_OFFSET , value from column TZNAME from view V$TIMEZONE_NAMES has to be used.

But the problem is TZNAME column does not have entry for many timezones , example SST, NDT, ADT . How can I get the timeoffset for these ??
Awaiting your answer eagerly!

Thanks and regards,
Aparna Received on Mon Jan 14 2008 - 14:16:21 CST

Original text of this message