Re: Sysdate problem......

From: Tim Sawmiller <sawmillert_at_state.mi.us>
Date: Thu, 07 Sep 2000 07:29:05 -0400
Message-Id: <10612.116390@fatcity.com>

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 -----=20
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Wednesday, September 06, 2000 11:04 AM

> Hi list,

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

>=20

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

>=20

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

>=20


> TO_CHAR(

> --------      Note : not getting value from system date

> 09:09:57             ,It should be 09:39:15

>=20

> SQL> /

>=20

> TO_CHAR(
> --------
> 09:09:59

>=20

> SQL> /

>=20


> TO_CHAR(

> --------       Note : The minute should be 10, not 09.

> 09:09:01

>=20
>=20

> Oracle 805 on Solaris 26.
> Thanks for any clue.

>=20
>=20

> Aldi
> Oracle DBA

>=20
>=20
>=20
>=20
>=20


> _________________________________________________________________________=

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

>=20

> Share information about yourself, create your own public profile at=20
> http://profiles.msn.com.

>=20

> --=20
> Author: Aldi Barco
> INET: ipal_at_hotmail.com=20

>=20


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

--=20
Author: Tom Pall
  INET: tom_at_cdproc.com=20

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 Received on Thu Sep 07 2000 - 06:29:05 CDT