Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Sysdate doesn't agree with date on Server

Re: Sysdate doesn't agree with date on Server

From: Timo Haatainen <timo.haatainen_at_pvo.fi>
Date: 1998/04/01
Message-ID: <01bd5d39$252458e0$e0758fc1@mmtth>#1/1

Verify that your Oracle server processes are running with the same TZ-variable set.

-- 

Timo Haatainen
PVO Engineering Oy


Tansel Ozkan <tansel_at_openix.com> kirjoitti artikkelissa
<35212B90.642C_at_openix.com>...

> Hello all,
>
> When I query the sysdate from Oracle, the time I am getting is different
> than the time on the server machine on which the database is residing.
> What could be the possible reasons for this?
>
> At SQLPlus prompt:
>
> select TO_CHAR(sysdate,'HH-MI-SS') from dual;
> TO_CHAR(SYSDATE,'HH-MI-SS')
> -------------------------------------------
> 10-51-13
>
>
> On Unix prompt:
>
> $date
> Tue Mar 31 12:51:13 EST 1998
>
> As you may have noticed, there is exactly a 2 hour of difference.
>
> Any comments..
>
> Thanks..
>
> Tansel
>
Received on Wed Apr 01 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US