Re: TO_DATE problem....

From: Ken Rachynski <krachyn_at_cadvision.com>
Date: Wed, 03 Feb 1999 08:45:31 -0700
Message-ID: <36B86F1B.6581AE7F@cadvision.com>

Raju,

From the manuals on DATE FORMATS:

MI specifies minute of the hour
MM specifies number of the month

rkarapp_at_uswest.com wrote:

> Hi,
> We have Oracle 7.3.2.3 installed on our HP machine. The OS is HP-UX 10.20.
> My Problem is the following :
>
> when I execute the sql query :
>
> 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.
>
> Can somebody tell me, what is the problem ?
>
> Thanks in adavance,
> Raju
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

--
Ken Rachynski
Database Analyst
krachyn_at_cadvision.com
<http://www.cadvision.com/krachyn>
ICQ: 3113514 Received on Wed Feb 03 1999 - 09:45:31 CST