Re: Date Time Format and milliseconds

If you have milliseconds and want to simply store them, then use an additional field (like MILLISECONDS NUMBER(3,0)).

If you want Oracle to tell you milliseconds then you can use the following function below (included in %ORACLE_HOME%/rdbms80/admin/DBMSUTIL.SQL):

function get_time return number;

• Find out the current time in 100th's of a second.
• Output argukments:
• get_time
• The time is the number of 100th's of a second from some
• arbitrary epoch.

I think you can only use this to compare to points in time and find out the millisecond difference, but you may find other uses...

-Frank

>
> Rolf
>
> Moonstone wrote:
> >
> > Hi,
> > is there a way to store milliseconds in a date field.
> > I tried to play around with the NLS_DATE_FORMAT but I didn't succeed until
> > now:
> > Any sugesstions ?
> >
> > Cheers
> > Eric
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Oct 21 1998 - 19:28:56 CDT