I am trying to update the date and time in a table that I have.
When I try to update it, the value in the MySQL database just gets reset to 00/00/00 00:00:00.
Here is the code I'm using in PHP:
"UPDATE Auction SET
endDateTime = '11/01/2009 13:23',
WHERE auctionID = '$auctionID'";
return mysql_query($sqlCommand, $this->connection);
Why does this not work?