Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: to_date and milliseconds
On Wed, 04 Jul 2007 18:56:12 GMT, "Ana C. Dent"
<anacedent_at_hotmail.com> wrote:
>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
Sure, and use a TIMESTAMP column in table instead of a DATE column.
-- Sybrand Bakker Senior Oracle DBAReceived on Wed Jul 04 2007 - 14:44:49 CDT