Re: Milliseconds and DATE field

Nice trick John, but this won´t do the work. Your statement will only print the seconds two times. So no milliseconds are displayed. Sorry ;-)

The only way to get 100ths of seconds (for instance between two procedure calls) is to use a database package (dbms_utility.get_time). So as of my knowledge there is no chance of storing and computing of date values including milliseconds. The only possibility is to make use of operating system calls and implement your own packages dealing with these values. Good luck :-)

Andy

John Chiu schrieb:

> 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:48:49 CST