Re: date and time?

From: Kenny Gump <kgump_at_mylanlabs.com>
Date: Fri, 8 Jan 1999 07:13:40 -0500
Message-ID: <3695f693.0@news.mountain.net>

A short answer is No. When Oracle stores a date internally it stores it in 7 bytes 1 for Century, 1 for Year, 1 for Month, 1 for Day, 1 for Hour, 1 for Minute, and 1 for Seconds. You can verify this by issueing the following query on any table that has a date field:

select dump(my_date)
from mytable;

Hope this is what you were looking for.

Kenny Gump
OCP 7.3 DBA

---

txm wrote in message <369550fe$0$19109_at_nntp1.ba.best.com>...
>>Also, is it possible to specify a Date field with more precision than
>>seconds? I'd like to go to milliseconds.
>
>I have a same question. Does anybody know about this?
>
>Thanks!
>
>
>txm
>
>
>
Received on Fri Jan 08 1999 - 06:13:40 CST