你即將離開本站

並前往https://frankcontrepois.com/post/20200824-tech-today-in-aws-athena/

Getting today and yesterday in AWS Athena - Frank Contrepois

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.

確定！ 回上一頁

查詢 「Postgres query today」的人也找了：

  1. PostgreSQL current time
    2.
  2. PostgreSQL WHERE date
    3.
  3. PostgreSQL interval '1 day
    4.
  4. PostgreSQL date
    5.
  5. PostgreSQL NOW format
    6.
  6. PostgreSQL CURRENT_DATE
    7.
  7. PostgreSQL month
    8.
  8. PostgreSQL date_trunc
    9.