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

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

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


Row for each date, start and end

Updated June 04, 2019 10:06 AM

calculate days spent of all visitors from encounters

Updated February 16, 2019 20:06 PM



Conversion from varchar2 to timestamp

Updated February 24, 2017 07:06 AM