Browse by Tags

• Datetime
• sqL Server 2000
• SQL Server 2005
• SQL Server 2008
• Teaser
• time

• Converting Columns To Date From Datetime Does Not Result In A Scan In SQL Server 2008

  I was reading Itzik Ben-Gan's An Introduction to New T-SQL Programmability Features in SQL Server 2008 article yesterday after one of my friends allerted me to the following from that article For example, the plan for the following query performs an index Read More... Posted Thursday, July 24, 2008 3:20 PM by Denis Gobo | 1 Comments Filed under: dates, SQL Server 2008

• Yet Another Date Teaser

  It has been a while since my last teaser but here we go What do you think the following returns? SELECT CONVERT ( datetime , '1/1/1' ) - CONVERT ( datetime , 1 ) + CONVERT ( datetime , 0 ) How about this on SQL Server 2008 SELECT CONVERT ( datetime2 , Read More... Posted Thursday, January 10, 2008 9:59 AM by Denis Gobo | 0 Comments Filed under: dates, 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) Read More... Posted Wednesday, October 10, 2007 11:46 AM by Denis Gobo | 6 Comments Filed under: dates, Datetime, sqL Server 2000, SQL Server 2005, Teaser

• SQL Server 2008 Has Nanosecond Precision?

  It looks like SQL Server 2008 has nanosecond precision for the time datatype [edit]I just looked at BOL and yes nanoseconds = ns, microsecond = mcs when used in dateadd[/edit] If you run the following DECLARE @t time SELECT @t = '0:0' SELECT @t AS Time1 Read More... Posted Wednesday, August 01, 2007 12:42 PM by Denis Gobo | 19 Comments Filed under: dates, SQL Server 2008, time