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

Thread: Days and time

  1. #1
    Join Date
    Jan 2004
    Posts
    25

    Days and time

    Hi all,

    Could anyone let me know how to calculate days and time between 2 dates.

    Regards
    Rangi

  2. #2
    Join Date
    Jun 2005
    Location
    London, UK
    Posts
    159
    Subtract one from the other to get decimal days (e.g. 1.5 = 36 hours).

    Convert to timestamps, then subtract one from the other to get result as an interval.

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