Re: Sysdate doesn't agree with date on Server

In article <6g0lka$14r5_at_piper.ncr.pwgsc.gc.ca>, Al <al_at_work> wrote:
>You have probably set a time zone environment variable in the .profile of
>the account that runs the oracle instances.
>
>. i.e.
>
>TZ=EST5EDT
>

And be sure both the environment that root uses and oracle uses export the TZ.

>
>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
>
>

-- 
These opinions are my own and not necessarily those of Information Quest
jgarry@eiq.com                           http://www.informationquest.com
http://ourworld.compuserve.com/homepages/joel_garry
"See your DBA?"  I AM the @#%*& DBA!