SQLblog.com - The SQL Server blog spot on the web

THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | Join | Help

in

Search

Opml

Browse by Tags

All Tags » Teaser » sqL Server 2000 » SQL Server 2005 » dates (RSS)

Datetime

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-2008 SQLblog.com^TM
Brought to you by Peter DeBetta & Adam Machanic

Powered by Community Server (Commercial Edition), by Telligent Systems

Privacy Statement