MySQL Help - Find difference between two dates

//VVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVV
// MySQL Help - Find difference between two dates
//VVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVV
<?
//programmer : Xyiry
// Oracle find different in days

$date1 = “07-OCT-06″;
$date2 = “26-sep-06″;

echo “Difference between $date1 and $date2 = “.diff_days($date1,$date2);

function diff_days($start_date, $end_date)
{
if ($start_date==”") return 0;
return floor((strtotime($start_date) - strtotime($end_date))/86400);
}
?>

About this entry

You’re currently reading “MySQL Help - Find difference between two dates,” an entry on Xyiry PHP Blog | Where Open Source Lives

Published:
08.10.07 / 4pm
Category:
MySQL