你即將離開本站

並前往https://www.codeproject.com/Questions/1136436/I-want-to-get-last-months-records-from-the-current

I want to get last 6 months records from the current date?

First, you have to find out the date that is six month older than now, to achieve this, use INTERVAL in PostgreSQL like this: JavaScript.

確定！ 回上一頁

查詢 「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.