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

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

Sysdate doesn't agree with date on Server

From: Tansel Ozkan <tansel_at_openix.com>
Date: 1998/03/31
Message-ID: <35212B90.642C@openix.com>#1/1

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 Tue Mar 31 1998 - 00:00:00 CST

Original text of this message

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