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