I still don't get why people when talking about Dates include a Time Component. Dates are Dates and Time is Time. We have had Date & Time Data Types for many years now but it seems SQL Server folk love their datetime and all of the Arcane knowledge required to use it.
Personally I'd like to see datetime deprecated so that we're left with Date, Time & DateTime2.
I'm interested to know who is still using datetime when all that they really want is Date.
End of Rant.