SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

TO_DATE - ignore character ?

602335Jan 23 2008 — edited Jan 23 2008

Hey guys!

I have to convert the given format: 2007-02-13T13:35:35.997 into a oracle date-datatype.

I am trying it this way:
TO_DATE(variable,'YYYY-MM-DDHH-MI-SS.FF3') but I am getting the error:
ORA-01821: date format not recognized or
ORA-01830: date format picture ends before converting entire input string

I think the problem is the "T" between date and time. So how can I ignore the T ?
Any ideas?

thanks and greets
bang

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 20 2008

Added on Jan 23 2008

10 comments

5,044 views