All Tags »
Teaser »
dates »
sqL Server 2000 »
Datetime »
SQL Server 2005 (RSS)
Sorry, but there are no more tags available to filter with.
-
What do you think will be the output? DECLARE @d datetime SET @d = '20071010' SELECT DATEADD(yy, DATEDIFF(yy, 0, @d)+1, -1)