Today Minus 15 Days Postgresql

[Solved] Today Minus 15 Days Postgresql | Sql - Code Explorer | yomemimo.com
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

Answers related to today minus 15 days postgresql

Code Explorer Popular Question For Sql