Re: TO_DATE

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: 2000/03/30
Message-ID: <8bvavv$d48$1@ctb-nnrp1.saix.net>#1/1

Sybrand Bakker wrote in message
<954411251.27671.0.pluto.d4ee154e_at_news.demon.nl>...
>Oracle doesn't capture fractions of a second, so the answer is no, you
can't
>do that.

Caveat though is that you can always store dates that includes decimal seconds as a number. It can then always be converted to date (by dividing the number by the number of decimals used for seconds and truncating the result).

Does Oracle not carry some kind of disclaimer in all its manual saying that the product should not be used for realtime critical and nuclear type applications, or whatever?

When dealing with second fragments, the device to collects the data needs to run in realtime. This of course excludes using Oracle, though Oracle can be used to store that data (in numerical format).

regards,
Billy Received on Thu Mar 30 2000 - 00:00:00 CST