Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: TO_DATE problem....

Re: TO_DATE problem....

From: Mike Morgan <mmorgan1_at_mail.tds.net>
Date: Tue, 2 Feb 1999 20:55:46 -0600
Message-ID: <798dr0$5q@news2.tds.net>


Common mistake. The format for MINUTES is 'mi' not 'mm'. Try using 'mm/dd/yy hh24:mi:ss' for your format mask. Also, as a matter of taste, I would recommend using a 4-digit year - i.e. 1998 and 'yyyy'. That way there is no question what is meant.

--Mike



[snip]
>
> SELECT LOGID FROM FLOG WHERE ACCESS_TIMESTAMP =
> TO_DATE('12/12/98 20:34:29', 'mm/dd/yy hh24:mm:ss') ;
>
> It gives me the following error
>
> ORA-01810: format code appears twice.
[snip] Received on Tue Feb 02 1999 - 20:55:46 CST

Original text of this message

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