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: 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

Original text of this message

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