Since the question didn't ask what version of SQL Server, none of the answers are correct. In SQL 2005, you get an error message, yet you still get one row selected.

Msg 2715, Level 16, State 7, Line 2

Column, parameter, or variable #4: Cannot find data type Date.