Convert string to date type in Athena AWS SQL

Question

I have a column that called date with the following format : '20220816' how can I convert this column into Date format?

I tried to use this function : date_parse(date,'%y/%m/%d') but it keep giving me this error: NVALID_FUNCTION_ARGUMENT: Invalid format: "20220627" is malformed at "220627"

Prabhakar Reddy · Accepted Answer · 2022-08-15 13:12:10Z

0

You have to remove the slashes from your query. Below query convert it to date format for you. Just replace the string with the column containing values

select cast(date_parse('20220816','%Y%m%d') as date)

answered Aug 15, 2022 at 13:12

Prabhakar Reddy

5,22421 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Convert string to date type in Athena AWS SQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related