This function will return the difference between two date - MYSQL DATE/DATETIME format. Ability to return the Minutes/Hours/Days/Weeks/Months/Years time difference.


<?php

//Find the difference in months (MYSQL DATETIME/DATE Format)
function find_difference($start_date,$end_date){
list($date,$time) = explode(' ',$start_date);
if($time == NULL){$time = '00:00:00';}
$startdate = explode("-",$date);
$starttime = explode(":",$time);

list($date,$time) = explode(' ',$end_date);
if($time == NULL){$time = '00:00:00';}
$enddate = explode("-",$date);
$endtime = explode(":",$time);

$secons_dif = mktime($endtime[0],$endtime[1],$endtime[2],$enddate[1],$enddate[2],$enddate[0]) - mktime($starttime[0],$starttime[1],$starttime[2],$startdate[1],$startdate[2],$startdate[0]);

//Different can be returned in many formats
//In Minutes: floor($secons_dif/60);
//In Hours: floor($secons_dif/60/60);
//In days: floor($secons_dif/60/60/24);
//In weeks: floor($secons_dif/60/60/24/7;
//In Months: floor($secons_dif/60/60/24/7/4);
//In years: floor($secons_dif/365/60/24);

//We will return it in months
$difference = floor($secons_dif/60/60/24/7/4);

return $difference;
}
echo find_difference('2005-05-12','2006-05-13 00:00:00');?>