Today minus 15 days postgresql

--yesterday
SELECT NOW() - INTERVAL '1 DAY';

--Unrelated to the question, but PostgreSQL also supports some shortcuts:
SELECT 'yesterday'::TIMESTAMP, 'tomorrow'::TIMESTAMP, 'allballs'::TIME;

Source: stackoverflow.com

Similar codes

65 votes549 views6 answers
Sql add column to table
SQL
0 vote176 views1 answer
Mql5 list all available symbols
SQL
0 vote187 views1 answer
Oracle webcenter content search enginer
SQL
2 votes199 views2 answers
How to run postgresql in linux
SQL
0 vote190 views1 answer
How to see password mysql vestacp
SQL
0 vote286 views1 answer
Oracle db get table sizes
SQL
0 vote181 views1 answer
Docker export psql sql
SQL
0 vote192 views1 answer
Sql on-premises
SQL
0 vote191 views1 answer
How to connect sqlalchemy to mysql and deploy it
SQL
1 vote172 views1 answer
Index a database column sql
SQL