How to add time to DateTime in SQL

Question

I'm trying to add custom time to datetime in SQL Server 2008 R2.

Following is what I've tried.

SELECT DATEADD(hh, 03, DATEADD(mi, 30, DATEADD(ss, 00, DATEDIFF(dd, 0,GETDATE())))) as Customtime 

Using the above query, I'm able to achieve it.

But is there any shorthand method already available to add custom time to datetime?

Answer 1

Try this

SELECT DATEADD(day, DATEDIFF(day, 0, GETDATE()), '03:30:00') 

Answer 2

For me, this code looks more explicit:

CAST(@SomeDate AS datetime) + CAST(@SomeTime AS datetime)