Milliseconds in Oracle

[CHALAVADI]

Can someone please tell me how to calculate time between two dates in milliseconds.
Thanks.

[tamilselvan]

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

[DaPi]

*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).