Converting DATETIME to a human readable date

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

You need to turn the date into a timestamp before passing it to date()

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

Answer 2

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.