Sql

Search

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;

Comment

current date in postgresql minus 1 day

CURRENT_DATE-INTERVAL '1 DAY'

Comment

PREVIOUS	NEXT

Code Example
Sql :: mysql update join
Sql :: how to drop all tables in sql
Sql :: oracle sql select all days between two dates except weekends
Sql :: sql server select first day of previous year
Sql :: check postgresql version in rails console
Sql :: sql convert date to string yyyy-mm-dd
Sql :: how to run mysql on terminal mac
Sql :: SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key"
Sql :: write sql query to find the second highest salary of employee
Sql :: DATE_SUB postgres
Sql :: difference between super key and candidate key
Sql :: sql find duplicate records in two tables
Sql :: add column postgres with default value
Sql :: check table exist postgresql
Sql :: print hello world in plsql
Sql :: select 2 rows in sql
Sql :: difference between primary key and unique key
Sql :: mssql check if date is greater than today
Sql :: adding constraints to columns SQL
Sql :: oracle drop sequence
Sql :: sql count unique values in one column
Sql :: dual in db2
Sql :: sql injection payload list github
Sql :: ERROR 3948 (42000): Loading local data is disabled; this must be enabled on both the client and server sides
Sql :: mysql query with sql to get the next row
Sql :: query distinct
Sql :: SQL: get date difference in minutes
Sql :: mysql ilike
Sql :: pagination in sql
Sql :: select random sample sql

Search

SQL

today minus 15 days postgresql

current date in postgresql minus 1 day

ADD CONTENT