| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Date Time Format and milliseconds
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
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 Mon Oct 19 1998 - 07:25:19 CDT
 |
 |