Check out example codes for "sql '=' cannot be applied to date varchar(10) athena". It will help you in understanding the concepts better.

Code Example 1

#cast it to a DATE format

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

Learn ReactJs, React Native from akashmittal.com