你即將離開本站

並前往https://stackoverflow.com/questions/24929735/how-to-calculate-date-difference-in-postgresql

How to calculate DATE Difference in PostgreSQL?

CREATE OR REPLACE FUNCTION datediff(timestamp, timestamp) RETURNS int LANGUAGE sql AS $$ SELECT CAST($1 AS date) - CAST($2 AS date) as DateDifference $$;.

確定！ 回上一頁

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

  1. PostgreSQL DATEDIFF days
    2.
  2. Postgresql interval to days
    3.
  3. PostgreSQL today
    4.
  4. PostgreSQL date_part
    5.
  5. PostgreSQL EXTRACT
    6.
  6. postgresql now - 7 days
    7.
  7. PostgreSQL age
    8.
  8. PostgreSQL date_trunc
    9.