SQL Server adding two time columns in a single table and putting result into a third column

Question

I have a table containing two time columns like this:

Time1       Time2  
07:34:33    08:22:44

I want to add the time in both these columns and put the result of addition into a third column may be Time3

Any help would be appreciated..Thanks

Answer 1

If the value you expect as the result is 15:57:17 then you can get it by calculating for instance the number of seconds from midnight for Time1 and add that value to Time2:

select dateadd(second,datediff(second,0,time1),time2) as Time3 
from your_table

I'm not sure how meaningful adding two discrete time values together is though, unless they are meant to represent duration in which case the time datatype might not be the best as it is meant for time of day data and only has a range of 00:00:00.0000000 through 23:59:59.9999999 and an addition could overflow (and hence wrap around).

If the result you want isn't 15:57:17 then you should clarify the question and add the desired output.