SQL adding Time?

[rsunra]

G'day

I want to add a Varchar field that is in the format HH:mm:ss I have no problem selecting and converting it but How can I just get the SUM of all selected fields



SELECT ( CONVERT (datetime , Call_duration , 14 )
FROM SMDR


Something like


SELECT SUM ( ( CONVERT (datetime , Call_duration , 14 ) )
FROM SMDR


Thanks for you help and cheers

Rich

 

[nagornyi]

An option would be to convert the HH:mm:ss strings to seconds, sum them up, and then convers back to HH:mm:ss.