CODEWITHSUNDEEP
sqloracle-databaseinsertto-dateora-00900
Atlas91
Atlas91

Reputation: 5904

ORA-00900: invalid SQL statement on to_date in oracle

I get an error in a INSERT. The problem is in this line:

to_date('05-JUN-13 01.09.10.000000 PM','DD-MON-YY HH.MI.SS.FF')

I don't know how resolve it. I tried also with 

to_timestamp('05-JUN-13 01.09.10.000000 PM','DD-MON-YY HH.MI.SS.FF')

But i had this error: 

ORA-01830: date format picture ends before converting entire input string

Any helps? Thanks a lot

Upvotes: 0

Views: 1151

Answers (1)

wolφi
wolφi

Reputation: 8361

The AM/PM format is missing, therefore the "date format picture" (what a wonderful name!) ends too early. Just use

to_timestamp('05-JUN-13 01.09.10.000000 PM', 'DD-MON-YY HH.MI.SS.FF6 AM')

Upvotes: 3

Related Questions