SQL: Is there a more efficient way to calculate elapsed hours, minutes, seconds?
- by hamlin11
I'm using Computed Columns to provide me with the following information:
Hours, Minutes, and Seconds between a Start DateTime and Finish DateTime (Where Minutes and Seconds are between 0 and 59 and Hours can be any value 0 or greater)
Computed Column for Seconds:
datediff(second,[Start],[Finish]) % 60
Computed Column for Minutes:
floor(datediff(second,[Start],[Finish]) / 60.0) % 60
Computed Column for Hours:
floor(datediff(second,[Start],[Finish]) / 3600.0)
Here's the table for reference
Note: I'm also calculating TotalElapsedSeconds, TotalElapsedMinutes, and TotalElapsedHours in other computed columns, but those are easy. I just feel like I might be missing out on a nice built in function in SQL.
