THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web
Sign in
|
|
in
Current Tags
(Entire Site)
Search
Home
Blogs
Downloads
Opml
Browse by Tags
All Tags
»
SQL Server 2005
»
Datetime
(RSS)
dates
sqL Server 2000
Teaser
SQL Teaser: Guess the output
What do you think will be the output? DECLARE @d datetime SET @d = '20071010' SELECT DATEADD(yy, DATEDIFF(yy, 0, @d)+1, -1)
Posted to
Denis Gobo
(Weblog)
by
Denis Gobo
on
October 10, 2007
©2006-2012 SQLblog.com
TM
Brought to you by
Adam Machanic
&
Peter DeBetta
Privacy Statement