Search
 
SCRIPT & CODE EXAMPLE
 

SQL

postgresql subtract date/hours

SELECT date '2022-10-12' - interval '7 days';
SELECT date '2022-10-12' - interval '24 hours';
Comment

PREVIOUS NEXT
Code Example
Sql :: alter table add column in sql server 
Sql :: difference between join vs union 
Sql :: postgresql remove new line from string 
Sql :: how to access to mysql without root 
Sql :: dual in db2 
Sql :: sql distinct only one column 
Sql :: add multiple row table pl sql 
Sql :: c# sqldatareader to list 
Sql :: postgresql delete multiple rows 
Sql :: regexp in mysql 
Sql :: current date in sql 
Sql :: select * where id = 1,2,3 
Sql :: rename a column in sql server 
Sql :: SQL Less Than or Equal to Operator 
Sql :: get all columns in a table sql 
Sql :: enable full text search mysql 
Sql :: sql period overlap 
Sql :: mysql create procedure phpmyadmin 
Sql :: influxdb list all tags for a measurement 
Sql :: postgres dump sql insert 
Sql :: sqlalchemy empty table 
Sql :: alter table primary key postgresql 
Sql :: get initials name in sql 
Sql :: sql update multiple columns 
Sql :: second highest salary in sql 
Sql :: sql right join 
Sql :: delete from IN subquery 
Sql :: ms sql server port 
Sql :: pl sql search in all packages 
Sql :: psql get last rows 
ADD CONTENT
Topic
Content
Source link
Name
1+9 =