Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Date format in INSERT Sql

Date format in INSERT Sql

From: <nitinvraj_at_gmail.com>
Date: 24 Nov 2005 02:41:06 -0800
Message-ID: <1132828866.662365.273610@f14g2000cwb.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US