Hi All,
Answering my own question here, maybe this will help others out:
I found a nifty function below that will return seconds from Unix epoch to a
mysql value in the datetime format. I'll just compare this to the php
function time(). Let me know if anyone has a better solution.
<?
############
# C2001 CodeHeadz.net
# Function is released under the GPL and is free as long as
# this header remains intact
#############
function datetime_to_epoch($date) {
$break = explode(" ", $date);
$datebreak = explode("-", $break[0]);
$time = explode(":", $break[1]);
$epoch = date("U",
mktime($time[0],$time[1],$time[2],$datebreak[1],$datebreak[2],$datebreak[0])
);
$datetime = date("Y-m-d H:i:s",
mktime($time[0],$time[1],$time[2],$datebreak[1],$datebreak[2],$datebreak[0])
);
}
?>
-----Original Message-----
From: Ryan Schefke [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 16, 2004 12:43 PM
To: Php-General-Help
Subject: [PHP] PHP & MySQL DATE comparison
Hello,
I'm pulling a date in the "datetime" format via a MySQL query. Using PHP I
would like to check if that date is prior to today's date. Can someone
please help with this quick question.
Thanks,
Ryan
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
