Interesting links

• Using Athena from the AWS CLI on Linux
• Getting today in Athena
• Getting today in PostgreSQL
• How to get the metadata of AWS Athena tables
• Get the number of columns in an AWS Athena table

Getting today and yesterday in AWS Athena

Dates are always a pain to manage. SQL is no exception with every database doing their way.

Today I talk about AWS Athena where the date/time documentation is here, not on the AWS website but the presto one. Interesting.

This query return 2020-08-24 and this is today

 SELECT current_date AS today_in_iso;

This query return 2020-08-23 and this is yesterday

SELECT current_date - interval '1' day AS yesterday_in_iso;

I love the interval datatype, it reminds me of PostgreSQL. Also no need for a FROM.