How to compare datetime's current_timestamp?

[Techissue2008]

I set 2 date variable in mysql by inserting as current_timestamp with datetime column

How can I compare them?

$T1 > $T2

2008-04-22 17:43:35 > 2008-04-22 17:24:29

Seems it does not compare with each other.

[NogDog]

If you are comparing them within SQL, then you should be able to compare them directly if they are both DATETIME columns. But if you are comparing the returned values within PHP, then you might be best served by first converting them to UNIX timestamp integers via [man]strtotime/man, then comparing those values.

[i-keng]

use this function , it will returns

<0 --> if date a< date b
0 --> date a== date b

0 --> date a > date b respectively.

   function compareDate ($i_sFirstDate,$i_sSecondDate){
	$arrFirstDate = explode ("/", $i_sFirstDate);
	$arrSecondDate = explode ("/", $i_sSecondDate);

$intFirstDay = $arrFirstDate[0];
$intFirstMonth = $arrFirstDate[1];
$intFirstYear = $arrFirstDate[2];

$intSecondDay = $arrSecondDate[0];
$intSecondMonth = $arrSecondDate[1];
$intSecondYear = $arrSecondDate[2];

$intDate1Jul = gregoriantojd($intFirstMonth, $intFirstDay, $intFirstYear);
$intDate2Jul = gregoriantojd($intSecondMonth, $intSecondDay, $intSecondYear);

return $intDate1Jul - $intDate2Jul;
   }