Re: timezone

In article <8rkpid$bjk$1_at_nnrp1.deja.com>,   zyman_at_my-deja.com wrote:
> Hi,
> I just want to know how can i get a _current_ timezone in Oracle using
> SQL?
> P.S. answer like " go to shell and run DATE " not interested. I want
 to
> get a timezone using sql or max. pl/sql. Calls for unix api not
 welcome.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Since Oracle relies upon the underlying operating system clock for time values the timezone is not available from any system tables/views that I am aware of (and I have checked both 7.3.4 and 8.1.6). I have even checked the Oracle Time Series functions and have found nothing in the way of timezone information.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.