Re: Sysdate doesn't agree with date on Server

From: Al <al_at_work>
Date: 1998/04/02
Message-ID: <6g0lka$14r5@piper.ncr.pwgsc.gc.ca>#1/1

You have probably set a time zone environment variable in the .profile of the account that runs the oracle instances.

. i.e.

TZ=EST5EDT Tansel Ozkan wrote in message <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 Thu Apr 02 1998 - 00:00:00 CST