sql server 2008 - 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')