Date format of json php

Question

I need to format the date time to a more readable format for instance a format, something like:- '23rd September 2018 17.00'

//Json Array

instances": [
{
"start": "2017-08-02T14:15:00"
}
]

//CODE
$count = count($characters->instances);
for(reset($i); $i < $count; ++$i) {
print_r ($characters->instances[$i]->start);
}

Answer 1

Instead I used 'Square Bracket' notation and echo instead of print_r which worked with strtotime, just adjusting the json_decode to true.

It worked!

Final Working Code

$characters = json_decode($data, true);

echo (date('jS  F Y h:i', strtotime($characters['instances'][$i]['start'])));

Answer 2

First, let's convert your JSON to an array.

// The 'true' parameter will convert your
// json to an array instead of an object
$characters = json_decode($json, true);

Now, let's loop through your array to find and replace the dates.

foreach ($characters['instances'] as $instanceKey => $instance) {
    foreach ($instance as $key => $value) {
        // Add all keys you'd like to change to the below array
        if (in_array($key, ['start', 'end', 'date'])) {
            $oDate = DateTime::createFromFormat('Y-m-dTH:i:s', $value);

            // You can adjust the date format to any format you wish
            // in the below format() portion
            $characters['instances'][$instanceKey][$key] = $oDate->format('jS  F Y h:i');
        }
    }
}

Now, let's turn it back into a JSON string:

$json = json_encode($characters);

I might've guessed your JSON structure wrong. But I think this will only be a minor adjustment. For any questions, you can of course leave a comment.

Answer 3

You can use function date() in php

print_r (date('jS  F Y h:i', strtotime("2017-08-02T14:15:00")));