we have sql server table with a decimal time duration column (in milliseconds) for each detail record. The column name is "duration". Example of the records values:
rec 1 468
rec 2 2375
rec 3 1172
if we need to know the total time duration for the 3 records can we just sum the 3 records and then covert to time format.
i was using: sum(cast (duration as bigint) as TotDuration