| 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
![]() |
![]() |