Re: How to find time offset from timezone information in Oracle
From: Aparna <Aparna.Nar_at_gmail.com>
Date: Mon, 14 Jan 2008 12:16:21 -0800 (PST)
Message-ID: <c245716d-77ad-480c-beeb-35193c5a67ca@d70g2000hsb.googlegroups.com>
Date: Mon, 14 Jan 2008 12:16:21 -0800 (PST)
Message-ID: <c245716d-77ad-480c-beeb-35193c5a67ca@d70g2000hsb.googlegroups.com>
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