Sysdate problem......

From: Aldi Barco <ipal_at_hotmail.com>
Date: Wed, 06 Sep 2000 21:52:47 JAVT
Message-Id: <10611.116301@fatcity.com>

Hi list,

I've just restored (copy from physical backup) the database and now have strange problem in sysdate : sysdate does not take the correct time and the minute part does not move forward.

SQL> !date
Wed Sep 6 09:39:14 CDT 2000

SQL> select to_char(sysdate,'HH:MM:SS') from dual;

TO_CHAR(
-------- Note : not getting value from system date
09:09:57 ,It should be 09:39:15

SQL> / TO_CHAR(

---

09:09:59

SQL> / TO_CHAR(
-------- Note : The minute should be 10, not 09.
09:09:01

Oracle 805 on Solaris 26.
Thanks for any clue.

Aldi
Oracle DBA

---

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at Received on Wed Dec 31 1969 - 17:59:59 CST