向mysql数据库插入当前日期的错误?
向mysql数据库插入当前日期语句:
$quer= "INSERT INTO user (user,password,email,time) VALUES ('$user','$ps','$email',date( ))";
运行报错,显示time字段有问题
改为:
$quer= "INSERT INTO user (user,password,email,time) VALUES ('$user','$ps','$email',date('y-m-d' ))";
也报错,显示time字段有问题
再改为 :
$quer= "INSERT INTO user (user,password,email,time) VALUES ('$user','$ps','$email',date('yyyy-mm-dd' ))";
也报错,显示time字段有问题
那么正确的写法是什么?