I have a SQL table with StartDate and LockTime columns in datetime format.
I want to do an update query to a calculated column in the same table called TimeDifference in Hour, Min, Sec format.
SET TimeDifference = LockTime - StartDate
Sometimes the hour differences can be greater than 24 and 48 hours. For example, 52:20:10 (52 hours, 20 minutes and 10 seconds)