AWS Athena date sql query

Question

Below is the data in csv file in s3 bucket which I have used to build Athena database.


John	Wright	cricket	25
Steve	Adams	football	30

I am able to run the query and get the data.

Now I am trying to fetch date of birth based on age column. Is it possible to generate date of birth from age column like current date - age (column) and print only the date of birth?

I tried below query but not sure whether it is correct way

select (current_date - interval age day) from table_name;

Please help me with this.

You can't transform age in years into full birth date for obvious reason - you can get only the year of birth. — Guru Stron
– Guru Stron, Commented Sep 5, 2021 at 17:53
You may get year of birth iff age in csv file is calculated based on today's date. Otherwise, you'll endup with wrong year of birth in edge cases. — Ash
– Ash, Commented Sep 6, 2021 at 2:51

Theo · Accepted Answer · 2021-09-07 14:22:04Z

2

You can use the date_add function, like this:

SELECT date_add('year', -age, current_date) FROM table_name

I.e. subtract age number of 'year'(s) from the current date.

answered Sep 7, 2021 at 14:22

Theo

133k22 gold badges170 silver badges213 bronze badges

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

1 Comment

sudhir Over a year ago

Thanks for the answer. I will ty this

Collectives™ on Stack Overflow

AWS Athena date sql query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related