Thanks for the tips on DATENAME (a function I think I'd used awhile back but had faded from my memory)

I too would have done something like (limiting the convert output...

What perfect timing, the sp_updatestats stored procedure took a query that was taking 3 minutes to run down to 1 second.