php写日期字串到mysql datetime字段

mysql 表结构如下:

create table datetime_tbl(dateField datetime);

 

1) php写入当前日期代码:

$sqlStr= "insert into datetime_tbl(dateField) values('now()')";

 

2) php写给定日期如:'2010/11/06 00:00:00':

$datetimeStr='2010/11/06 00:00:00';

//转化成mysql中datetime格式字串

$datetime = date('Y-m-d H:i:s',strtotime($datetimeStr)); //不转化也可以，sqlStr中直接使用$datetimeStr

$sqlStr = "insert into datetime_tbl values('".$datetime."')";