willsherwood
asked on
PHP: compare (<) two times given in MySQL text format
I have echoed the two times (as an example) of a comparison i'm trying to do:
2011-02-22 16:42:05 < 2011-02-22 16:38:11
I've tried: comparing the two text strings directly(!); strcmp(); and strtotime < strtotime
how is the best way to do this successfully? (the strlen is always the same)
thanks
2011-02-22 16:42:05 < 2011-02-22 16:38:11
I've tried: comparing the two text strings directly(!); strcmp(); and strtotime < strtotime
how is the best way to do this successfully? (the strlen is always the same)
thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
$date1='2011-02-22 16:42:05';
$date2='2011-02-22 16:38:11';
if(strtotime($date1) < strtotime($date2))
{
echo "ok";
}
$date2='2011-02-22 16:38:11';
if(strtotime($date1) < strtotime($date2))
{
echo "ok";
}
ASKER
(something else was amiss and i was blaming it on the < comparison!)
appreciated