Re: oracle sysdate vs. unix system time

From: Lawrence Simela <lsimela_at_mahalini.prestel.co.uk>
Date: Tue, 25 Sep 2001 15:19:12 +0100
Message-ID: <9oscsg$sp6$2@phys-ma.sol.co.uk>

Could this be a timezone issue?

Lawrence

"NDJ" <natashadj_at_hotmail.com> wrote in message news:469c4fa9.0109240623.5b3aca79_at_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 Tue Sep 25 2001 - 09:19:12 CDT