PHP Unknown datetime format from JSON

Question

I'm eceiving an unknown datetime format from a JSON file:

"expectedStartTime":1431469800000

anyone recognize this format, and can guide me into how to convert it to "YYYY-MM-DD H:i:s" format?

so it should be date("Y-m-d H:i:s", ($expectedStartTime/1000)) — steven
– steven, Commented May 12, 2015 at 19:39

steven · Accepted Answer · 2015-05-12 19:47:20Z

1

Expecting it is a timestamp in milliseconds it should work like this:

$json = '{"expectedStartTime":1431469800000}';

$arr = json_decode($json,true);

echo date("Y-m-d H:i:s", $arr['expectedStartTime']/1000);

The given value will output:

2015-05-13 00:30:00

answered May 12, 2015 at 19:47

steven

4,8952 gold badges31 silver badges61 bronze badges

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

1 Comment

Phil Over a year ago

It should be noted that this is only correct in the UTC+2 timezone. I guess you live in Europe somewhere. If the OP needs to write it as UTC to a database, they should probably use the DateTime object or make sure their PHP timezone is UTC inside their application.

Phil · Accepted Answer · 2015-05-12 19:58:37Z

0

It is a Java style unix timestamp which is miliseconds from the epoch. You can divide by 1000 and treat it as a normal Unix timestamp like this.

$expectedStart = new DateTime("@" . ($time/1000));
print $expectedStart->format("Y-m-d H:i:s");

answered May 12, 2015 at 19:58

Phil

2,3411 gold badge23 silver badges27 bronze badges

Collectives™ on Stack Overflow

PHP Unknown datetime format from JSON

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related