Finding precise difference in time and date values

What is the best function/way to find the difference in time and date value in the range of 1/1000th precision?

e.g., Time: 25.456 (sec) - 22.349 (sec)
Time: 25-Sep-06 15:44:22.453 - 20-Sep-06 17:22:45.276

    Requires Free Membership to View

    Login

The only Oracle datatype that will handle fractional seconds is the TIMESTAMP datatype. Once you have two values stored as timestamps, the easisest way to find the difference is to just subtract the two values. For instance: 
SELECT TO_TIMESTAMP('MM/DD/YY HH24:MI:SS.SSS','09/25/06 15:22:22.453') - 
              TO_TIMESTAMP('MM/DD/YY HH24:MI:SS.SSS','09/20/06 17:22:45.276') 
FROM dual;

This was first published in October 2006

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top