Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Date format in INSERT Sql
Pls help ...
why this sql statement shows error
ORA-01855: AM/A.M. or PM/P.M. required
INSERT INTO TESTTABLE
(testid, testdatetime)VALUES ( 1, TO_DATE('24-11-2005 06:07 AM', 'DD-MM-YYYY HH:MI AM')); Nitin. Received on Thu Nov 24 2005 - 04:41:06 CST