Change date in JSON with PHP

Question

I have a few dates in my JSON file and I wonder how I can rewrite the output of them.

Current date: 2018-03-04T23:40:46.94 How it should be: 04/03/2018

Current JSON:

 {
    "SKU": "PQ-70-7EF",
    "ParentSKU": null,
    "Category": "Alarm clocks",
    "EAN": "4971850420019",
    "Title": "Casio Wakeup timers",
    "Description": "Casio Wakeup timers",
    "Brand": "CASIO",
    "RRP": 56,
    "Price": 26.1,
    "PriceUpdateUTC": null,
    "Stock": 0,
    "StockUpdateUTC": "2018-03-04T23:40:46.94",
    "Images": [
        {
            "ImageSort": null,
            "ImageURL": "https://uwt.blob.core.windows.net/dsales/partimage/pq-70-7ef_kniwoz.jpg",
            "IsDefault": true
        }
    ]
}

Current script:

foreach ($data as $key => $entry) {
    $data[$key]['StockUpdateUTC'] = date('d/m/Y');
}

The above script is changing all dates to today's date. Thanks for the help.

Regards Ely

Not certain why you would want to change that. When it comes to dates, either persisting them or sending on a wire in some kind of API, you should prefer UTC (as in your actual format). — YvesLeBorg
– YvesLeBorg, Commented Mar 5, 2018 at 14:27

Syscall · Accepted Answer · 2018-03-05 14:25:46Z

2

You have to convert the current string date to a timestamp (using strtotime()) and then pass this timestamp as the second argument of date().

foreach ($data as $key => $entry) {
    $data[$key]['StockUpdateUTC'] = date('d/m/Y', strtotime($data[$key]['StockUpdateUTC']));
}

answered Mar 5, 2018 at 14:25

Syscall

19.8k10 gold badges44 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

PedroFaria99 · Accepted Answer · 2018-03-05 14:30:45Z

2

You can pass the date variable as a parameter in the date() function, like this:

foreach ($data as $key => $entry) {
    $data[$key]['StockUpdateUTC'] = date('d/m/Y',strtotime($data[$key]['StockUpdateUTC']));
 }

This way it will convert your date, instead of using the current one.

EDIT: As mencioned by Syscall, u need to convert your string to a actual date, using strtotime()

edited Mar 5, 2018 at 14:30

answered Mar 5, 2018 at 14:23

PedroFaria99

4845 silver badges14 bronze badges

4 Comments

random_user_name Over a year ago

This is correct, but why not link the date() reference to the PHP documentation for reference?

Ely Fornoville Over a year ago

This changes the date for all to: "StockUpdateUTC": "01/01/1970".

Niklesh Raut Over a year ago

Need to use strtotime here like Syscall.

PedroFaria99 Over a year ago

Yeah i forgot about that, apologies.

Collectives™ on Stack Overflow

Change date in JSON with PHP

2 Answers 2

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related