Re: SYSDATE and timezone

From: Jim Burkman <jburkman_at_indiana.edu>
Date: Mon, 08 Oct 2001 15:14:44 GMT
Message-ID: <Epjw7.40652$Xk4.2982833@news1.rdc1.sdca.home.com>

Well, 8i does have the NEW_TIME function that you can use to convert from one time zone to another...

Jim

"Thomas Kyte" <tkyte_at_us.oracle.com> wrote in message news:9p9htu02a16_at_drn.newsguy.com...
> In article <9p9gbt$f99$00$1_at_news.t-online.com>, "Nicolas says...
> >
> >I want to check the server time against the local time. Receiving the
local
> >time (using delphi) and the timezone is not the problem. But how to do it
> >from Oracle?
> >
> >select sysdate from dual returns the current time including the timezone
on
> >the server. Or does I am wrong?
> >
>
> sysdate from dual returns the current time IN THE servers timezone (not
> including -- the timezone component is not available with sysdate).
>
> In 9i, you can get a timestamp with timezone. In 8i there is no timezone
> support in the database.
>
> see
>

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:452820143 983
>
> for methods to retrieve the server timezone using Java or C called from
the
> database in 8i and 8.0.
>
>
> >Regards
> >
> >Nicolas
> >
> >
>
> --
> Thomas Kyte (tkyte@us.oracle.com) http://asktom.oracle.com/
> Expert one on one Oracle, programming techniques and solutions for Oracle.
> http://www.amazon.com/exec/obidos/ASIN/1861004826/
> Opinions are mine and do not necessarily reflect those of Oracle Corp
>
Received on Mon Oct 08 2001 - 10:14:44 CDT