mysql 输入时间格式_以日期时间格式mySQL插入当前日期

I'm having problems getting the date inserted properly into my database.

$date = date('m/d/Y h:i:s', time());

I use this format, and, it echoes out correctly, however, when, I insert

mysql_query("INSERT INTO table

(dateposted)

VALUES ('$date')");

it doesn't appear to work successfully, and, the time remains 00:00:00

If you could find the solution that would be great, thanks.

解决方案

If you're looking to store the current time just use MYSQL's functions.

mysql_query("INSERT INTO `table` (`dateposted`) VALUES (now())");

If you need to use PHP to do it, the format it Y-m-d H:i:s so try

$date = date('Y-m-d H:i:s');

mysql_query("INSERT INTO `table` (`dateposted`) VALUES ('$date')");