athena SYNTAX_ERROR: line 30:24: Cannot check if timestamp is BETWEEN varchar(10) and date code example

Example: sql '=' cannot be applied to date varchar(10) athena

#cast it to a DATE format

WHERE observation_date > CAST('2017-12-31' AS DATE)