Re: timezone

YEhh, U are right.
for getting timezone information they propouse 2 ways: 1. Wait for new oracle release :)
2. Use external procedures.
so let's wait for new release :))

In article <8rks8q$dvh$1_at_nnrp1.deja.com>,   oratune_at_aol.com wrote:
> 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.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Oct 09 2000 - 09:51:51 CDT