Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Sysdate doesn't agree with date on Server
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')
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 Tue Mar 31 1998 - 00:00:00 CST