to_date and milliseconds

From: Lucas Carvalho Teixeira <lucascarvalho_at_gmail.com>
Date: Wed, 04 Jul 2007 18:42:47 -0000
Message-ID: <1183574567.465035.260160@g4g2000hsf.googlegroups.com>

Hello,
I am trying to convert a string to date.

INSERT INTO table VALUES (to_date('2007-01-11 14:46:28.035','yyyy-mm- dd hh24:mi:ss.??'));

I was trying to use ms or ff3 where are the "??" and I am getting an error:

         ERROR at line 1:
         ORA-01821: date format not recognized

I can not convert this date with milliseconds, but without milliseconds works perfectly: to_date('2007-01-11 14:46:28','yyyy-mm- dd hh24:mi:ss').
Any Idea?!

Thank you. Received on Wed Jul 04 2007 - 13:42:47 CDT