/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 vote184 views1 answer
Sqlite referential integrity
SQL
0 vote181 views1 answer
Oracle query archivemode
SQL
0 vote186 views1 answer
Mysql_error replacement
SQL
8 votes208 views1 answer
Alter tablespace add datafile autoextend
SQL
0 vote223 views1 answer
Mysql config address
SQL
0 vote191 views1 answer
Postgresql extract hour and minutes from timestamp
SQL
26 votes195 views2 answers
Mysql workbench download
SQL
1 vote168 views1 answer
Ms sql - add one hour to time
SQL
0 vote137 views1 answer
Mssql view column data type
SQL
0 vote212 views1 answer
Call function in query sql server
SQL