Using datetime data types in a WHERE clause

Mixing DATE, DATETIME, DATETIME-TZ in a WHERE clause or in other comparisons will cause compile time errors and are not valid comparisons.