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

Thread: Milliseconds in Oracle

  1. 07-07-2004, 11:09 AM #1
    CHALAVADI
    CHALAVADI is offline Junior Member
    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
    Reply With Quote Reply With Quote
  2. 07-07-2004, 01:24 PM #2
    tamilselvan
    tamilselvan is offline Senior Advisor
    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
    Reply With Quote Reply With Quote
  3. 07-07-2004, 01:43 PM #3
    DaPi's Avatar
    DaPi
    DaPi is offline Old Cranky Philosopher
    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).
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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