Re: Milliseconds and DATE field

This is in fact incorrect. The DATE datatype does NOT include milliseconds. This is a much requested enhancement, though. The only way I know of getting milliseconds is using the GET_TIME function. You would need to store the milliseconds as a separate number column, then concatenate them for user display.

HTH. Pete

Gerald Winslow wrote:

> 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:57:14 CST