Xref: alice comp.databases.oracle.misc:25686
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!newsfeed.cwix.com!204.246.1.19!news.tds.net!news
From: "Mike Morgan" <mmorgan1@mail.tds.net>
Newsgroups: comp.databases.oracle.misc
Subject: Re: TO_DATE problem....
Date: Tue, 2 Feb 1999 20:55:46 -0600
Organization: TDSNET Internet Services(http://www.tds.net)
Lines: 18
Message-ID: <798dr0$5q@news2.tds.net>
References: <79889l$89f$1@nnrp1.dejanews.com>
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3

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]