Athena date_parse error - malformed error

[satishrandive]

hi,

Can someone please assist to resolve following error -

An error occurred while loading the data.
[Simba]AthenaJDBC An error has been thrown from the AWS Athena client. INVALID_FUNCTION_ARGUMENT: Invalid format: "04-apr-2022" is malformed at "apr-2022"

I am trying to convert the string to date format

sample string -
16-apr-2022
10-may-2022
06-apr-2022

code ( used in select clause)- date_parse("date_string"."date",'%d-%m-%y') as New_date

Thank you