http://sqlblog.com/blogs/denis_gobo/archive/tags/Teaser/SQL+Server/default.aspxTags: Teaser, SQL ServerenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlblog.com/blogs/denis_gobo/archive/2007/06/01/1368.aspxFri, 01 Jun 2007 08:32:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:1368Denis Gobo7http://sqlblog.com/blogs/denis_gobo/comments/1368.aspxhttp://sqlblog.com/blogs/denis_gobo/commentrss.aspx?PostID=1368http://sqlblog.com/blogs/denis_gobo/rsscomments.aspx?PostID=1368<P>Just to clarify, summer starts Memorial Day and ends Labor Day. I will post a teaser every Friday until Labor Day.</P> <P>Got this from my friend George, try to guess the output of the code below without running it.</P> <P>&nbsp;</P><FONT color=#0000ff size=2> <P>SET</FONT><FONT size=2> </FONT><FONT color=#0000ff size=2>DATEFORMAT</FONT><FONT size=2> DMY</P></FONT><FONT color=#0000ff size=2> <P>SELECT</FONT><FONT size=2> </FONT><FONT color=#ff00ff size=2>CONVERT</FONT><FONT color=#808080 size=2>(</FONT><FONT color=#0000ff size=2>DATETIME</FONT><FONT color=#808080 size=2>,</FONT><FONT size=2> </FONT><FONT color=#ff0000 size=2>'120607'</FONT><FONT color=#808080 size=2>)</P></FONT> <P>&nbsp;</P><img src="http://sqlblog.com/aggbug.aspx?PostID=1368" width="1" height="1">SQL ServerTeaser