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?
See Question&Answers more detail:os