declare @updatedate as datetime set @updatedate ='2011-03-25' -- getdate() (time at that time) was 2011-03-25 10:17:15.000 select DATEADD(day, 0, DATEDIFF(day, 0, @updatedate)) + DATEADD(day, 0 - DATEDIFF(day, 0, getdate()), getdate()) --not sure how that turned out to be 21:10:15:000
|MS SQL Inner Join - Multiple Join Parameters||2||23|
|Getting same value for every field in SQL||2||33|
|Executing SSIS with a Stored Procedure Permissions||12||29|
|Business Intelligence Software recommended for high level non-IT staff with non-update privileges on SQL Server||5||12|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
26 Experts available now in Live!