[SOLVED] comparing dates

[hassank1]

Hi

I've retreived a mysql (date/time) field from a database .. and I want to compare it with the current time .. (for example return 1 if > , 0 if = , -1 if < )

 

Note : I also want the time 2 be compared not only if the date are the same .. ex same date but different times then they are not equal..

 

thx

[Mchl]

Do it in MySQL itself

http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html

[hassank1]

I will check that..thx

 

however I still need a php function or method to do the same task.

[Mchl]

Easiest would probably be to convert date retrieved from database to unix datestamp using strtotime and compare it with current time as returned by time

[hassank1]

aha gr8 .. thanks..

[Mchl]

Here's something I've come up with. Not tested

 

//$timestamp1,$timestamp2 should be unix timestamps
function compareTime($timestamp1,$timestamp2) {
if ($timestamp1 == $timestamp2) {
  return 0;
} else {
  return ($timestamp1 - $timestamp2)/ abs($timestamp1 - $timestamp2);
}
}

echo compareTime(strtotime($dateFromMySQL),time());