Sample columns
date_col:
2007-05-06 00:00:00.000
time_col:
1971-01-01 01:06:23.000
Use this…
DATEADD(hh ,DATEPART(hh, [time_col]]), DATEADD(n ,DATEPART(n, [time_col]) , DATEADD(ss ,DATEPART(ss, [time_col]) , [date_col])))
To get this…
2007-05-06 01:06:23.000
Leave a comment:
