oracle sysdate vs. unix system time

From: NDJ <natashadj_at_hotmail.com>
Date: 24 Sep 2001 07:23:47 -0700
Message-ID: <469c4fa9.0109240623.5b3aca79@posting.google.com>

Hi,

I am using Oracle 8.1.7 under Solaris 2.5 and have following issue:

Sysdate in Oracle is more than 1 min late than the Unix system time. This is causing confusion when we update date and time stamp from Pro*C calls using Unix system time.

---

  1* alter session set nls_date_format='yyyymmdd-hh24miss' SQL> /   Session altered.  

SQL> select sysdate from dual;  

SYSDATE

---

20010924-092449  

SQL> !date
Monday September 24 09:25:58 EDT 2001  

SQL> /   SYSDATE

---

20010924-092452  

SQL> !date
Monday September 24 09:26:01 EDT 2001  

SQL>

---

Any suggestions ? Received on Mon Sep 24 2001 - 09:23:47 CDT