AWS Builder Center: Learn, Build and Connect with builders in the AWS community
AWS Builder Center is the official home for builders on AWS. Share and read what others are working on, follow people who inspire you, explore training and workshops, and find tools to support what you're building.
Athena date_parse week format bug
1
I cannot retrieve the date of the week 1 of 2025 when querying in athena. Please consider the below queries. I commented the value I'm getting on each expression.
select
date_parse('2025-1', '%Y-%v') as date_of_2025_1, -- 2025-12-29 00:00:00.000
date_parse('2024-1', '%Y-%v') as date_of_2024_1, -- 2024-01-01 00:00:00.000
date_parse('2024-52','%Y-%v') as date_of_2024_52, -- 2024-12-23 00:00:00.000
-- date_parse('2024-53','%Y-%v') as 'date of 2024-53' -- doesn't compile
week(date_parse('2024-12-30', '%Y-%m-%d')) as week_of_2024_12_30 -- 1
Surely, date_parse('2025-1','%Y-%v') should not return the date 2025-12-29?