Milliseconds in Oracle
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Milliseconds in Oracle

  1. #1
    Join Date
    Sep 2000
    Posts
    77

    Milliseconds in Oracle

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

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    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

  3. #3
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    *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
  •  


Click Here to Expand Forum to Full Width