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 :: get database size mysql
Sql :: sql server reset identity
Sql :: postgres active connections
Sql :: postgresql reset sequence
Sql :: mysql status
Sql :: convert utc to est sql
Sql :: oracle get table schema
Sql :: stop mysql
Sql :: start postgresql
Sql :: oracle sql limit results
Sql :: grant revoke privileges to mysql username
Sql :: oracle list columns
Sql :: mysql return 0 if null
Sql :: how to export database mysql terminal ubuntu
Sql :: sql drop procedure if exists
Sql :: oracle to_timestamp
Sql :: get the next auto_increment value mysql
Sql :: postgres regex remove special characters
Sql :: search stored procedures by name
Sql :: rermove categories woocommerce sql
Sql :: delete first row in sql
Sql :: mssql show database size
Sql :: update column name and datatype in sql
Sql :: change varchar length mysql
Sql :: mysql count words
Sql :: import dump mysql
Sql :: sql how to replace full stop
Sql :: show structure of table in sql
Sql :: sqlite3 how to get column names of a table
Sql :: cross schema query oracle 2 users

Search

SQL

today minus 15 days postgresql

current date in postgresql minus 1 day

ADD CONTENT