Re: Milliseconds and DATE field

Kim, If I'm not mistaken the built-in function SYSDATE (which returns the current date and time) incorporates milliseconds automatically. So, if you're wanting to save milliseconds and your column type is DATE, then just do this:

INSERT INTO table VALUES (..., SYSDATE, ...);

Gerald Winslow

"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 Thu Dec 16 1999 - 15:06:48 CST