Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: [HELP] 0.01 second -> date type

Re: [HELP] 0.01 second -> date type

From: Kurt Laugesen <kul_at_post3.tele.dk>
Date: Wed, 2 Dec 1998 16:46:59 +0100
Message-ID: <743nkr$3j1q$1@news-inn.inet.tele.dk>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US