Message-Id: <10611.116349@fatcity.com> From: "Tom Pall" Date: Wed, 6 Sep 2000 15:46:22 -0500 Subject: Re: Sysdate problem...... MM is the mask for month. Try MI ----- Original Message ----- From: Aldi Barco To: Multiple recipients of list ORACLE-L Sent: Wednesday, September 06, 2000 11:04 AM Subject: Sysdate problem...... > 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@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@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).