RE: Sysdate problem......

Good catch!

Regards,

Waleed

-----Original Message-----
From: Tim Sawmiller [mailto:sawmillert_at_state.mi.us] Sent: Thursday, September 07, 2000 8:31 AM To: Multiple recipients of list ORACLE-L Subject: Re: Sysdate problem......

You are using an incorrect format. MM is the month, MI is for minutes.

>>> tom_at_cdproc.com 09/06/00 05:50PM >>>
MM is the mask for month. Try MI
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Wednesday, September 06, 2000 11:04 AM

> 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).
>

-- 
Author: Tom Pall
  INET: tom_at_cdproc.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).

-- 
Author: Tim Sawmiller
  INET: sawmillert_at_state.mi.us

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