how to add time

Question

Good Morning,

I have two fields
tran_in (deatetime) = "2020-09-21 15:42:39.000"
tran_desc2 (char(30)) = "00:03:59"

I need to add these two fields

Thank you !!!

Answer 1

Declare @Sample Table(tran_in datetime, tran_desc2 char(30));  
Insert @Sample(tran_in, tran_desc2) Values('2020-09-21 15:42:39.000', '00:03:59')  
Select tran_in, tran_desc2, DateAdd(second, DateDiff(second, '19000101', tran_desc2), tran_in) As SummedDate  
From @Sample;  

Tom

Answer 2

Check a sample:

declare @example as table ( tran_in datetime, tran_desc2 char(30) )

insert into @example values ( '2020-09-21 15:42:39.000', '00:03:59' )

select *,
    tran_in + tran_desc2
from @example