Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: to_date and milliseconds

Re: to_date and milliseconds

From: <sybrandb_at_hccnet.nl>
Date: Wed, 04 Jul 2007 21:44:49 +0200
Message-ID: <c4un83h7riuccd7cj318k6v94942646qep@4ax.com>


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 DBA
Received on Wed Jul 04 2007 - 14:44:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US