Re: Date Time Format and milliseconds

From: Winnie Liu <oracle_dba_at_zdnetmail.com>
Date: Mon, 19 Oct 1998 22:45:32 -0700
Message-ID: <70h7ok$3gp@dfw-ixnews4.ix.netcom.com>

Wait a second. There is an Oracle dynamic table which store the millisecond information. It's something like v$timer. (please do go and double check). I forget exactly what that values mean, please do lookup the documentation for that. The oracle date format will NOT store the millisecond information. But you can create another column and store the information in the v$timer into it.

Winnie
Certified DBA

Thomas Kyte wrote in message <362b2f4b.827159_at_192.86.155.100>...
>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.
Received on Tue Oct 20 1998 - 00:45:32 CDT