你即將離開本站

並前往https://stackoverflow.com/questions/3928575/postgresql-checking-date-relative-to-today

PostgreSQL, checking date relative to "today" - Stack Overflow

select * from mytable where mydate > now() - interval '1 year';. If you only care about the date and not the time, substitute current_date ...

確定！ 回上一頁

查詢 「PostgreSQL today」的人也找了：

  1. PostgreSQL current time
    2.
  2. PostgreSQL today date
    3.
  3. PostgreSQL CURRENT_TIMESTAMP
    4.
  4. postgresql interval '1 day
    5.
  5. PostgreSQL now 7 days
    6.
  6. Postgres query today
    7.
  7. PostgreSQL date_part
    8.
  8. PostgreSQL weekday
    9.