find difference in dates sql
snippet in sql

difference in dates sql

user3013

SELECT (END_DATE - START_DATE) Days-Total FROM MyTable
/*this works for oracle sql*/

find difference in dates sql

user8590

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