-
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
-
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
There are 5 new data types:
TIMESTAMP
TIMESTAMP WITH TIME ZONE
TIMESTAMP WITH LOCAL TIME ZONE
INTERVAL YEAR TO MONTH
INTERVAL DAY TO SECOND
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|