hi..guys
can we track milliseconds in oracle(it is possible in mssql)
if yes how,if no then oracle is not useful when milliseconds come into picture
Printable View
hi..guys
can we track milliseconds in oracle(it is possible in mssql)
if yes how,if no then oracle is not useful when milliseconds come into picture
Hi,
You can use dbms_utility.get_time or query from v$timer synonym
to get time in milliseconds. This is for calculating time
difference. Date field is stored upto the precision of second.
In Oracle 9i is possible another way.
hop this helps.
Regards
Hello,
In Oracle 9i, a new datatype by the name of : TIMESTAMP gives date&time with miliseconds (fractional seconds).
Best Regards
There are 5 new data types:Quote:
Originally posted by noor
Hello,
In Oracle 9i, a new datatype by the name of : TIMESTAMP gives date&time with miliseconds (fractional seconds).
Best Regards
TIMESTAMP
TIMESTAMP WITH TIME ZONE
TIMESTAMP WITH LOCAL TIME ZONE
INTERVAL YEAR TO MONTH
INTERVAL DAY TO SECOND