Date and datetime types in SQL cannot be compared directly

Title, today the problem of a day tangled.

The time of two datetime types is defined in the stored procedure, and then this two time is used as the two time periods for the between of a date field in the Where condition, and the result is not executed anyway ...

Just like update table1 set col1=2 where date1 between Datetime1 and datetime2 this.

Don't laugh, little brother take a note, summarize the detour--type compatibility problem

Date and datetime types in SQL cannot be compared directly