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
|
Results 1 to 3 of 3
Thread: Milliseconds in OracleThreaded View
|
Click Here to Expand Forum to Full Width |