/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

0 vote283 views1 answer
Oracle change password expiration policy
SQL
0 vote285 views1 answer
Sql query tags
SQL
0 vote294 views1 answer
How to check database engine in mysql
SQL
0 vote266 views1 answer
Insert value list does not match column list: 1136 Column count doesn't match value count at row 2"
SQL
5 votes300 views2 answers
Mysql dump mysql db cli
SQL
0 vote294 views1 answer
Oracle webcenter content search enginer
SQL
1 vote285 views1 answer
Oracle drop job if exists
SQL
20 votes278 views3 answers
SQL query rename table
SQL
0 vote282 views1 answer
How to to get time in sql
SQL
0 vote258 views1 answer
Sql server update top n records
SQL