title: Calculate DateDiff in SQL in Days:Hours:Mins:Seconds format
body: <p>I am currently working an SQL script to calculate the difference between two dates which would give me the result in DD:HH:MI:SEC format.
  Example: 
  Date 1: 7/30/12 4:00 PM
  Date 2: 5/4/12 10:31 AM</p>
  
  <p>And the result should be 87:05:29:00</p>
  
  <p>Can you kindly help with the script for this?
  Regards,
  Arjun</p>