I get it, I should have used the DATE data type instead of DATETIME2 for the question so I could have left off the time portion on the answers. How about everyone just quit complaining about that, this wasn't a test for the eyes.

I found out about a behaviour regarding datetime conversions that existed starting in SQL Server 2008 with the addition of several new date/time data types that I wasn't aware of and that wasn't even described why it was happening and I dug into it more. I thought it would be a great QotD and submitted it.

Also, for the code as presented, there is only one correct answer.

The reason I didn't give only 2 possibilities is that I didn't want it to be a 50/50 guess. I was trying to make it a bit more challenging than that.