My datetime article updated for 2008

THX for your wonderful update - Frank Kalis will make an updated translation of your great "white paper"

CU

tosc

"Translate-worthy" that`s what I mean :-)

Once more thanks for your great work!

CU

tosc

Hi,

I believe this is quicker for SQL2008 to remove time part.

Nice article by the way :)

Jon

--Type alternative

SET @t = GETDATE()  

SELECT  

CAST(CAST(date_time AS DATE) AS DATETIME)

,COUNT(*)  

FROM dbo.date_table  

GROUP BY CAST(CAST(date_time AS DATE) AS DATETIME)

OPTION (MAXDOP 1);  

SELECT DATEDIFF(ms, @t, GETDATE()) AS "Type alternative"