How do I convert this time format?

Question

2011-07-13 02:38:31

^ MySQL format.

I would like to use PHP to convert it to another format like , July 13, 2011 2:38 am.

possible duplicate of [How to format this date (dd/mm/yyyy) into (j M Y) in PHP?](http://stackoverflow.com/questions/6692294/how-to-format-this-date-dd-mm-yyyy-into-j-m-y-in-php) — genesis, Jul 17 '11 at 18:31
check this: [http://stackoverflow.com/questions/2487921/php-convert-date-format-yyyy-mm-dd-dd-mm-yyyy-not-in-sql][1] [1]: http://stackoverflow.com/questions/2487921/php-convert-date-format-yyyy-mm-dd-dd-mm-yyyy-not-in-sql — Tepken Vannkorn, Jul 17 '11 at 18:33
check this: [http://stackoverflow.com/questions/2487921/php-convert-date-format-yyyy-mm-dd-dd-mm-yyyy-not-in-sql][1] [1]: http://stackoverflow.com/questions/2487921/php-convert-date-format-yyyy-mm-dd-dd-mm-yyyy-not-in-sql — Tepken Vannkorn, Jul 17 '11 at 18:34

score 5 · Accepted Answer · answered Jul 17 '11 at 18:29

5

<?php
$time_from_db = '2011-07-13 02:38:31';

echo date('F j, Y g:i a', strtotime($time_from_db));
?>

answered Jul 17 '11 at 18:29

Shef

genesis · Answer 2 · 2011-07-17T18:35:50.897

4

echo date("F j, Y g:i a", strtotime("2011-07-13 02:38:31"));

edited Jul 17 '11 at 18:35

answered Jul 17 '11 at 18:30

genesis

edited! [demo](http://sandbox.phpcode.eu/g/d6834.php) (you could remove your downvote,maybe?) – genesis Jul 17 '11 at 18:35
Yes, which is exactly like mine posted 8mins ago. I removed the down vote obviously. – Shef Jul 17 '11 at 18:38

score 1 · Answer 3 · edited Jul 17 '11 at 18:33

1

$yourdatevar = date("F j, Y, g:i a", strtotime($yourdatevar)); // March 10, 2001, 5:16 pm

edited Jul 17 '11 at 18:33

answered Jul 17 '11 at 18:31

Leopold Stotch

3 Answers3