Viewing post 1 (of 1 total)
My experience are just opposite. DATENAME is slower than CONVERT + DATEPART. See below:
/*------------------------
DECLARE @Bitbucket CHAR(4);
PRINT '========== DATENAME Method of Conversion ==========';
...
January 20, 2011 at 6:23 am
#1275852