How to Combine to values into datetime

Question

How to combine two values into a datetime field

 Example value 1 = 2010-10-26 00:00:00.000 (datetime)
 Example value 2 = 1650 (varchar)

 Desire Result 2010-10-26 16:50:00.00

Could you explain logic to combine? Get date part from value1, get time part from value2? — Pham X. Bach, Mar 12 '18 at 01:31

score 2 · Accepted Answer · answered Mar 12 '18 at 01:34

2

You can add datetimes together in SQL Server. The trick is getting the time from the second one:

select (value1 +
        cast(cast(stuff(value2, 3, 0, ':') as time) as datetime)
       )

Alternatively, if value2 is an integer, you could do:

select dateadd(minute,
               (value2/100)*60 + value2%100,
               value1
              )

answered Mar 12 '18 at 01:34

Gordon Linoff

1 Answers1