Your entry cannot be converted to a valid datetime value.
In general, the ANSI standard date format is used with databases that represent dates using a true date data type. In contrast, the datetime format is used with databases that support a datetime data type.
Data Type Conversion | Query Fundamentals |
Expressions | Using the Select List |
Filtering Rows with WHERE and HAVING |