Date Subtraction or Difference

Sometimes you need to know the differences between two dates in days months years whatever.


select datediff(day,date1, date2) as days_diff,
datediff(month,date1, date2) as months_diff...

Can also do year, quarter, week, hour, minute, and second dateparts.
Dates can be hard coded or column names.

Coldfusion Function

#DateDiff("datepart", "date1", "date2")#
datepart (yyyy, q, m, w, h, n, s)


A little tricker so further research may be needed to get the expected results.
var DateDiff = {

inDays: function(d1, d2) {
var t2 = d2.getTime();
var t1 = d1.getTime();

return parseInt((t2-t1)/(24*3600*1000));


var day_diff = datediff("day", date1, date2);

Cup size   
Select size then click on coffee cup.
This entry was posted in Code, Coldfusion, Javascript, JQuery, Snippets, SQL and tagged . Bookmark the permalink.