I am rather surprised at the low percentage of correct answers.
Incorrect answers: 63% (129)
Total attempts: 205
And the implications this could have to those designing a DB, and inadvertently or deliberately using different definitions for a date time object in different tables (based only on each individual table's requirements) and then, when selecting, wondering why Select statements using a join / case / where on a date column do not return the correct data.