comparing dates

[Anon]

Is there a function I can use to compare dates.

[Anon]

May be, it will help? $first_date and $second_date are in MySQL format(YYYY-mm-dd)

$arr_Y_m_d_first=explode('-', $first_date);
$arr_Y_m_d_second=explode('-', $second_date);

$seconds_first=mktime(0,0,0,$arr_Y_m_d_first[1],$arr_Y_m_d_first[2],$arr_Y_m_d_first[0]);

$seconds_second=mktime(0,0,0, $arr_Y_m_d_second[1],$arr_Y_m_d_last[2], $arr_Y_m_d_second[0]);

Now you can compare two dates when they are the seconds:
if ($seconds_first<$seconds_second){...}

[Anon]

Are you comparing MySQL or PHP dates? what exactly are you comparing them to? Do you want to find which one is older, younger, if it's more than 30 days old? Some more info, please. There are many methods you can use both in PHP and MySQL. The example Annchen gave will work, but it's a lot easier to do it in MySQL, depending on what you are looking for.

---John Holmes...

[saravanan1979]

I think u guys are unecessarily complicating things,PHP i quite kind to us.Top compare 2 dates it is enough if u use
$date1<$date2,PHP will automatically do the comparision for u