/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

14 votes216 views3 answers
Trim sql
SQL
0 vote206 views1 answer
Mysql query to check record exists in database table or not
SQL
0 vote191 views1 answer
Mysql percentage of total
SQL
12 votes204 views4 answers
Mysql ifnull
SQL
6 votes255 views2 answers
Oracle undotbs usage
SQL
0 vote220 views1 answer
Change database name psql 8
SQL
3 votes217 views3 answers
Mysql declare variable
SQL
0 vote198 views1 answer
Sqlserver now
SQL
0 vote212 views2 answers
Sql max count
SQL
-1 vote213 views1 answer
Concat two columns in sql server
SQL