Re: Date Time Format and milliseconds

My only suggestion would be to use program to insert milliseconds into their own field. C counts time in milliseconds (I believe... it's been a while). If you get the time (with milliseconds), parse it to time, and milliseconds and store it into two fields, you could concat them when selecting from the table.

S Niemann

> >>A copy of this was sent to "Moonstone" <Moonstone_at_nowhere.com>
> >>(if that email address didn't require changing)
> >>On Mon, 19 Oct 1998 09:54:19 +0200, you 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
> >>>
> >>>
> >>
> >>No, the Oracle DATE datatype stores:
> >>
> >><quote src=server concepts manual>
> >>The DATE datatype stores point–in–time values (dates and times) in a
> >>table. The DATE datatype stores the year (including the century), the
> >>month, the day, the hours, the minutes, and the seconds (after
> >>midnight). Oracle can store dates ranging from Jan 1, 4712 BC through
> >>Dec 31, 4712 AD. Unless you specifically specify BC, AD date entries
> >>are the default.
> >>
> >>Oracle uses its own internal format to store dates. Date data is stored in
> >>fixed–length fields of seven bytes each, corresponding to century, year,
> >>month, day, hour, minute, and second.
> >></quote>
> >>
> >>There is no space for milliseconds in there.
> >>
> >>Thomas Kyte
> >>tkyte_at_us.oracle.com
> >>Oracle Government
> >>Herndon VA
> >>
> >>--
> >>http://govt.us.oracle.com/ -- downloadable utilities
> >>
> >>---------------------------------------------------------------------------
> >-
> >>Opinions are mine and do not necessarily reflect those of Oracle
> >Corporation
> >>
> >>Anti-Anti Spam Msg: if you want an answer emailed to you,
> >>you have to make it easy to get email to you. Any bounced
> >>email will be treated the same way i treat SPAM-- I delete it.
> >

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Nov 19 1998 - 08:49:30 CST