/SQL/Select current_timestamp - interval '3 days';

Select current_timestamp - interval '3 days';

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

Select current_timestamp - interval '3 days';

SELECT current_timestamp - interval "3 days";
-- 2020-06-24 08:25:31.759993 America/Los_Angeles

Source: prestosql.io

Similar codes

1 vote274 views1 answer
Sqlite create index
SQL
0 vote270 views1 answer
Sql query for displaying age from oldest to youngest
SQL
6 votes272 views2 answers
Sql display max value
SQL
0 vote298 views1 answer
Running percentage of total postgres
SQL
0 vote284 views1 answer
After kill process Failed to start mysqld.service: Unit mysqld.service not found.
SQL
1 vote333 views1 answer
Best configuration for display table in sqlplus
SQL
0 vote272 views3 answers
Postgresql allow remote connections
SQL
0 vote304 views1 answer
How to add mysql to path on termin after installation
SQL
0 vote264 views1 answer
Order by monthly in sql
SQL
2 votes301 views3 answers
Install mysql workbench ubuntu 20.04 terminal
SQL