将DATETIME转换为人类可读日期

Question

I'm trying to convert the DATETIME to something that people can actually use. This is the date:

2013-09-05 11:52:10

I'm using:

date("D, d M Y", '2013-09-05 11:52:10');

Is turning into:

Thu, 01 Jan 1970

Makes no sense to me.

Answer 1

Is this supposed to be PHP code? If so, the correct is

date("D, d M Y", strtotime('2013-09-05 11:52:10'));

If this has to do with MySql, the correct function to use is DATE_FORMAT (however, what you have is invalid MySql syntax). Please clarify.