Can someone please tell me how to calculate time between two dates in milliseconds.
Thanks.
Printable View
Can someone please tell me how to calculate time between two dates in milliseconds.
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).