Search
 
SCRIPT & CODE EXAMPLE
 

SQL

find difference in dates sql

SELECT DATEDIFF(day, date1,date2) AS DateDiff
/*
DATEDIFF accepts three arguments
1- day, month, year etc what form you need difference
2,3- dates 
*/
Comment

difference in dates sql

SELECT (END_DATE - START_DATE) Days-Total FROM MyTable
/*this works for oracle sql*/
Comment
PREVIOUS NEXT
Code Example
Sql :: split string and copy last element postgresql 
Sql :: mysql update multiple columns 
Sql :: SQL Copy From Two Tables to One 
Sql :: alter check constraint in mysql 
Sql :: sql track modification 
Sql :: select query in mongodb 
Sql :: mssql unique key accept nulls 
Sql :: sql check constraint 
Sql :: oracle synonym procedure 
Sql :: postgresql insert multiple rows 
Sql :: keys in sql with example 
Sql :: how to insert same table data using mysql query 
Sql :: sql server inner join 
Sql :: mysql max connections exceeded max_connections_per_hour 
Sql :: copy data from one database to another 
Sql :: psql: error: FATAL: database "odoo" does not exist 
Sql :: IntegrityError at duplicate key value violates unique constraint DETAIL: Key id already exists. 
Sql :: What is SQL data store? 
Sql :: connectionString 
Sql :: alter table add multiple columns mysql 
Sql :: sql replace null values with another column 
Sql :: update select sql 
Sql :: create database with hyphen sign mysql 
Sql :: sql online compiler 
Sql :: sql procedure 
Sql :: add column mysql 
Sql :: merge in sql 
Sql :: sql check if column exists 
Sql :: left join 
Sql :: sql download for windows 11 
ADD CONTENT
Topic
Content
Source link
Name
4+9 =