Re: Oracle
From: Ranga Chakravarthi <ranga_at_removethis.cfl.rr.com>
Date: Sat, 16 Mar 2002 01:55:25 GMT
Message-ID: <hCxk8.146955$Dl4.16592787_at_typhoon.tampabay.rr.com>
Date: Sat, 16 Mar 2002 01:55:25 GMT
Message-ID: <hCxk8.146955$Dl4.16592787_at_typhoon.tampabay.rr.com>
In 9i
SELECT CURRENT_TIMESTAMP FROM DUAL;
In 8i, you can write a Java stored procedure (if you have Java enabled) and
use the
System.currentTimeMillis() function to get the time in milliseconds
"Mahesh" <ms15beec_at_hotmail.com> wrote in message
news:9b64c2.0203150456.792a0504_at_posting.google.com...
> Can we store date-time upto milliSeconds accuracy in Oracle table? if
> possible, how to do this? And how to fetch records depending upon time
> (mSec)?
>
Received on Sat Mar 16 2002 - 02:55:25 CET