Re: to_date and milliseconds

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Wed, 04 Jul 2007 18:56:12 GMT
Message-ID: <g3Sii.4424$695.4380@newsfe06.phx>

Lucas Carvalho Teixeira <lucascarvalho_at_gmail.com> wrote in news:1183574567.465035.260160_at_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.
>
>

Use TO_TIMESTAMP in place of TO_DATE Received on Wed Jul 04 2007 - 13:56:12 CDT