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: Tom Pall <tom_at_cdproc.com>
Date: Wed, 6 Sep 2000 15:46:22 -0500
Message-Id: <10611.116349@fatcity.com>


MM is the mask for month. Try MI
----- Original Message -----
From: Aldi Barco <ipal_at_hotmail.com>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> 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_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:46:22 CDT

Original text of this message

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