date and time?

Unfortunately the long answer is no as well. The precision of Oracle dates is the nearest second. The get_time function in dbms_util will give you times in 100ths of a second since "some arbitrary epoch" I think this means since the instance was started . By juggling this you can get times to better precision. Beyond this your on your own.

-----Original Message-----
From: txm [mailto:txm_at_best.com]
Posted At: Friday, January 08, 1999 12:51 PM Posted To: server
Conversation: date and time?
Subject: Re: date and time?

Thank you for the info.

Do you have any long answer? What if I really need milliseconds?

Thanks!

txm

Kenny Gump wrote in message <3695f693.0_at_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 - 15:42:23 CST