/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

12 votes300 views1 answer
Docker run mysql image
SQL
0 vote324 views1 answer
Full outer join in mariadb mysql
SQL
0 vote322 views1 answer
Mysql insert into select transaction c#
SQL
1 vote281 views1 answer
Select random sample sql
SQL
6 votes313 views1 answer
Wordpress change user password sql
SQL
13 votes334 views3 answers
Insert mysql ifile nto database
SQL
33 votes314 views2 answers
Postgres how to add field created at
SQL
15 votes328 views4 answers
Mysql export database command line
SQL
3 votes273 views1 answer
How to get list of synonyms in oracle
SQL
0 vote368 views1 answer
Add two days to current date in sql when creating tables
SQL