Very useful, so posting here. Read the php date function page for more details.

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

Ref: http://stackoverflow.com/questions/136782/format-mysql-datetime-with-php