Hi guys,
I am performing following insert operation in oracle which gives me date error..
ORA-01830: date format picture ends before converting entire input string
insert into VISITOR_REG ( VISITOR_NAME,MOBILE_NO,COMPANY,PURPOSE,BRANCH_ID,DEPARTMENT,CONTACT_PERSON,CITY,VISIT_DATE,ENTRY_PERSON,EXIT_PERSON,STATUS,LUGGAGE ) values ('Darshin',9987854533,'web development','website development','B0001','C10001','E00001','Ahmedabad','04-MAY-11 10:09:59 PM','','','Pending','Laptop')
help if anybody knows the solution...