用于mysql查询的php日期格式

Question

I can't seem to find this answer.

what would be the php code for having date in this following format:
2012-11-29

$date = new DateTime();
$date = $date->format('F j, Y');

This give me in November 29, 2012

Answer 1

$date = new DateTime();
$date = $date->format('Y-m-d');

http://php.net/manual/en/function.date.php