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
