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