I have the following bit of code (disreguard the sql query routines. I am using the ones from phpnuke):
$game_when = "2002-01-01 1:00";
echo "date=$game_when<br>";
$result = sql_query("select unix_timestamp('$game_when')", $dbi);
list($timestamp1) = sql_fetch_row($result, $dbi);
echo "timestamp1: $timestamp1<br>";
$timestamp2 = strtotime($game_when);
echo "timestamp2: $timestamp2<br>";
echo "diff=" . ($timestamp1 - $timestamp2) . " <Br>";
echo("select unix_time($timestamp1), unix_time($timestamp2)<br>");
$result = sql_query("select from_unixtime($timestamp1), from_unixtime($timestamp2)", $dbi);
list($date1, $date2) = sql_fetch_row($result, $dbi);
echo "date1=$date1 date2=$date2<br>";
and I am coming out with this output:
date=2002-01-01 1:00p
timestamp1: 1009864800
timestamp2: 1009836000
diff=28800
select unix_time(1009864800), unix_time(1009836000)
date1=2002-01-01 01:00:00 date2=2001-12-31 17:00:00
Why am I getting this strange result for date2?
Is the date '20002-01-01 1:00p' not a valid date format? If not, does anyone have a routine that would validate the date against the GNU date syntax.
--joubert
