Insert date without using todate
445123Nov 28 2005 — edited Nov 29 2005Hi
Whenever I execute the following query I get an error
INSERT INTO HTCALLMASTER (CALLID,REFERENCEID,CALLERID,CATEGORYID,PROBLEMTITLE,PROBLEMDESCR,STARTDATETIME,STATUS,LOGMEDIUM) VALUES ('1122','12','M70615','1','DGFG','FDGDG','22-DEC-2005 08:20:56 AM',1,'APPLICATION');
The error returned is
ERROR at line 1:
ORA-01830: date format picture ends before converting entire input string
The query executes well using to_date function but I do not want to make use of it.
Please suggest the solution.