Welcome to EMC Consulting Blogs

SQL 2008 introduces the new DATE data type, and it is considerable quicker to CAST a DATETIME to this if you’re attempting to just extract the date part from a DATETIME field, than using the old method of

SELECT CONVERT(DATETIME,CONVERT(CHAR,GETUTCDATE(),102))

So from SQL 2008 onwards this can now be written as

SELECT CAST(GETUTCDATE() AS DATE)