How to add time from a Date value to another without a varchar conversion?

by minusnine   Last Updated October 18, 2019 20:06 PM

Let's say I have 2 variables in a Stored Procedure, both are Dates

Foo contains '13/10/2019 00:00:00'

Bar contains '01/10/1914 16:33:11'

I want to add Bar's time to Foo's date, so that I get a Foobar variable containing 13/10/2019 16:33:11

Is there a way to achieve this without converting any of them into a varchar?



Related Questions


Updated June 04, 2019 10:06 AM

Updated February 16, 2019 20:06 PM

Updated September 10, 2019 11:06 AM

Updated September 21, 2017 18:06 PM

Updated February 24, 2017 07:06 AM