Date format in INSERT Sql

Giganews Newsgroups
Subject: Date format in INSERT Sql
Posted by:  nitinvr…@gmail.com
Date: 24 Nov 2005

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.

Replies