mysql - php convert timestamp to specific format -

mysql - php convert timestamp to specific format -

i have 1 field registered_date timestamp type in mysql. new php need help.

i getting result: 2014-06-19 15:59:49

and want output: 19 june 2014 15:59 pm

note: storing timestamp in php variable sql query.

any idea?

http://php.net/manual/en/function.strtotime.php http://php.net/manual/pl/function.date.php

$date = date('d m y h:i a', strtotime($timestamp));

php mysql timestamp