INTERVAL 型

型の一種(査読中)

PostgreSQL で以下の動作確認

SELECT current_date;
    date    
------------
 2015-10-15
(1 row)

CREATE TABLE times (
  test_date DATE
    NOT NULL
);
INSERT INTO times VALUES ('2015-10-15');
INSERT INTO times VALUES ('2015-10-16');
INSERT INTO times VALUES ('2015-10-17');

SELECT * FROM times
WHERE test_date = (current_date + INTERVAL '1 DAY');
 test_date  
------------
 2015-10-16
(1 row)

PostgreSQL: Documentation: 9.5: Date/Time Functions and Operators