athenaで日付周りをいじる

解決

select from_iso8601_timestamp('2020-03-19T18:01:08+09:00'), -- 2020-03-19 18:01:08.000 +09:00 timestamp '2020-03-19 09:01:09 UTC' AT TIME ZONE 'Asia/Tokyo', -- 2020-03-19 18:01:09.000 Asia/Tokyo from_iso8601_timestamp('2020-03-19T18:01:08+09:00') > timestamp '2020-03-19 09:01:09 UTC' AT TIME ZONE 'Asia/Tokyo', -- false from_iso8601_timestamp('2020-03-19T18:01:08+09:00') > timestamp '2020-03-19 09:01:07 UTC' AT TIME ZONE 'Asia/Tokyo' -- true

参考

Presto/Athena Examples: Date and Datetime functions

Convert date columns to date type in generated Athena table · Issue #3 · concurrencylabs/aws-cost-analysis

8.13. Date and Time Functions and Operators — Presto 0.235 Documentation

AWS - Athenaで先週分がJSTで取れるビューを作る - Qiita