使用PHP将字符串时间戳转换为MySQL时间戳[duplicate]

Question

Possible Duplicate:
Converting string to MySQL timestamp format in php

Given a date in the following format, how would I convert it into a MySQL TIMESTAMP format in PHP?

Tue, 06 Dec 2011 16:47:11 +0000

I found a similar question, but am having some difficulty in converting it into what I need.

Answer 1

date('Y-m-d H:i:s',strtotime('Tue, 06 Dec 2011 16:47:11 +0000'))

that's 'canonical' form, but MySQL will also accept

date('YmdHis',strtotime('Tue, 06 Dec 2011 16:47:11 +0000'))

(more details about that format: http://dev.mysql.com/doc/refman/5.5/en/date-and-time-literals.html )