Converting time in PHP?

Question

How do i convert the time which I pull from a database 2009-09-27 23:58:54 to the following time using PHP Sep 27, 2009.

Answer 1

In PHP you can use strtotime or in MySQL you can use UNIX_TIMESTAMP to get the date into a timestamp.

You can then use the date function to format it as you want:

$timestamp = strtotime($myDate);
$dateStr = date('M j, Y', $timestamp);

Answer 2

<?php echo date('M j, Y', strtotime('2009-09-27 23:58:54')); ?>

Answer 3

If you're using MySQL then I would advise you use the MySQL date_format() function, something like this:

SELECT date_format(date, '%b %e,%Y') AS `formatted_date` FROM `table_name`;