Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: [HELP] 0.01 second -> date type
You can't!
Time in Oracle is measured down to a second as the most accurate.
If you need it more accurate you have to invent your own date-type and find
a way of getting the accurate time down to 0.01 sec - sysdate won't give it!
Regards
Kurt
young sang,jeong wrote in message <366497E3.876BEA0E_at_hanjinsec.co.kr>...
>hello ,
>i want your help
>when i store time to date field i accounted this problem:
>how store 0.01 second to date field
>date format-> yyyy mm dd hh24 mi ss
>ss is only integer so i couldn't use this format.
>
>anybody who knows this problem help me please!
>
Received on Wed Dec 02 1998 - 09:46:59 CST
![]() |
![]() |