convert datetime from mysql to human readable string

Question

I have a datetime that I get from a mysql table and I would like to display it as a string.It looks like the following and I would like it to look like July 14th 2016 at 5:00 PM.

2016-07-14 17:00:00

I tried formatting like the following, but it didn't work. How do i get it how I want?

    date_format($date, 'g:ia \o\n l jS F Y');

Answer 1

You just have to convert the $date to Timestamp using something like strtotime() perhaps and then pass this as the second argument to PHP's date() function. The First Argument would be the Format for the Date. This below illustrates it....

<?php
    $date   = "2016-07-14 17:00:00";
    $date   =  date('g:ia \o\n l jS F Y', strtotime($date));

    var_dump($date);
    // PRODUCES: '5:00pm on Thursday 14th July 2016'  (length=33);