Question : today minus 15 days postgresql
Answered by : excited-elk-dgooadynnv0y
--yesterday
SELECT NOW() - INTERVAL '1 DAY';
--Unrelated to the question, but PostgreSQL also supports some shortcuts:
SELECT 'yesterday'::TIMESTAMP, 'tomorrow'::TIMESTAMP, 'allballs'::TIME;
Source : https://stackoverflow.com/questions/46079791/subtracting-1-day-from-a-timestamp-date | Last Update : Thu, 12 Mar 20
Question : current date in postgresql minus 1 day
Answered by : jm
CURRENT_DATE-INTERVAL '1 DAY'
Source : | Last Update : Mon, 01 Mar 21