Horje
select current_timestamp - interval '3 days'; Code Example
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



Sql

Related
mysql dump with table query Code Example mysql dump with table query Code Example
mysql count rows returned Code Example mysql count rows returned Code Example
sql find second highest salary employee Code Example sql find second highest salary employee Code Example
sql select from multiple tables without join Code Example sql select from multiple tables without join Code Example
alter column to not null with default value sql server Code Example alter column to not null with default value sql server Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 7



 

Horje