Re: oracle sysdate vs. unix system time

In article <9oscsg$sp6$2_at_phys-ma.sol.co.uk>, "Lawrence says...
>
>Could this be a timezone issue?
>
>Lawrence
>

I didn't see the original post but my question is

• is SQLPlus running on the SAME server machine as the database? Are we looking at two different machines here? Is the database on server1 and sqlplus on server2 -- if so, you need to sync the unix clocks.

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

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp