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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Sysdate problem......

Re: Sysdate problem......

From: Lyall Barbour <lbarbour_at_stanford.edu>
Date: Wed, 06 Sep 2000 13:20:33 -0700
Message-Id: <10611.116343@fatcity.com>


Change your MM to MI. It's getting the 9th month (September) instead of the 39th minute.
Lyall

At 08:04 AM 9/6/00 -0800, you wrote:
>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
>http://profiles.msn.com.
>
>--
>Author: Aldi Barco
> INET: ipal_at_hotmail.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
Received on Wed Sep 06 2000 - 15:20:33 CDT

Original text of this message

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