Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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 - 14:50:37 CST
![]() |
![]() |