TO_DATE problem....

From: <rkarapp_at_uswest.com>
Date: Wed, 03 Feb 1999 01:21:04 GMT
Message-ID: <79889l$89f$1@nnrp1.dejanews.com>

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 Received on Tue Feb 02 1999 - 19:21:04 CST