Re: Milliseconds and DATE field

Hi John

...but how can I insert a record with milliseconds.

Something like
  INSERT INTO MYTABLE VALUES(TO_DATE(xxxxxxxxxx))

....but TO_DATE, as far as I can see, does not support milliseconds in the format string.

I don't think this is allowed:
  INSERT INTO MYTABLE VALUES('1999/12/13 11:23:12:567') Any other ideas ?

TIA
Kim Hellan

John Chiu wrote in message <832jho$ffc$1_at_news2.tor.accglobal.net>...
>O8IB > select to_char(sysdate,'yyyy/mm/dd hh24:mi:ssss') from dual;
>
>TO_CHAR(SYSDATE,'YYYY
>---------------------
>1999/12/13 05:29:3232
>
>HTH
>
>John Chiu
>
>
>Kim Hellan <khe_at_NOSPAMkmd.dk> wrote in message
>news:83297r$abt$1_at_news1.tele.dk...
>> Does the DATE field in Oracle8 support milliseconds ?
>>
>> If yes, how do I use SQL to INSERT a record with a date/time value in the
>> format 'YYYY-MM-DD hh:mm:ss:uuu', where uuu is the milliseconds ?
>>
>> If no, is there another field type that supports milliseconds (like the
>> DateTime field in an MS SQL Server) ?
>>
>> TIA
>> Kim Hellan
>>
>>
>
>
Received on Mon Dec 13 1999 - 06:20:09 CST