-
Milliseconds in Oracle
Can someone please tell me how to calculate time between two dates in milliseconds.
Thanks.
Thanks
-
select (sysdate - (sysdate - 2))*24*60*60 * 1000 from dual ;
When you subtract date from another date, the result in days. Multiply the result with 24*60*60*1000 to get milliseconds.
Tamil
-
*glutch* You do realise I hope, that DATES are stored only to the second. If you really need to measure/store fractions of second you need TIMESTAMP (from version 9).
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
|