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

Stormy Sloth answered on August 21, 2020 Popularity 4/10 Helpfulness 3/10

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

Comment

#cast it to a DATE format

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

Popularity 4/10 Helpfulness 3/10 Language sql

Source: Grepper

Tags: athena sql to-date

Link to this answer
Share Copy Link

Contributed on Aug 21 2020

Stormy Sloth

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

Oops, You will need to install Grepper and log-in to perform this action.