php timestamp to readable date not working as expected

Question

Im trying to convert my timestamp to a readable date (going to be used in a sql query).

My code:

$date1 = date("d-m-Y",Input::get('van'));
return Input::get('van')."  ".$date1;

The timestamp:

1451602800000

the result

15-12-1966

When i try this application the result of that timestamp is Thu, 31 Dec

2015 23:00:00 GMT

Which is what i was expecting. What am i doing wrong that makes me get the wrong day-month year? the timestamp seems to be oke the code is the accepted answer here:

Adding:

 date_default_timezone_set('UTC');

dosn't change anything

Its the value (from a get request) holding the exact timestamp. it could be any var holding that timestamp value. — Sven van den Boogaart
– Sven van den Boogaart, Commented Jul 5, 2016 at 23:31
Well, your 1451602800000 timestamp is for June 18 in the year 47969. — Brogan
– Brogan, Commented Jul 5, 2016 at 23:32
Brogan is that the date you get when entering it in the provided link? I get Assuming that this timestamp is in milliseconds: GMT: Thu, 31 Dec 2015 23:00:00 GMT — Sven van den Boogaart
– Sven van den Boogaart, Commented Jul 5, 2016 at 23:33

Brogan · Accepted Answer · 2016-07-05 23:43:10Z

1

Remove three zeros from the right of your timestamp. A Unix timestamp is represented in seconds, not milliseconds.

$date1 = date('d-m-Y', Input::get('van') / 1000);
return Input::get('van') . '  ' . $date1;

See the time function for an example of an acceptable timestamp that can be used with the date function.

edited Jul 5, 2016 at 23:43

answered Jul 5, 2016 at 23:37

Brogan

7627 silver badges16 bronze badges

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

Comments

Igor T. · Accepted Answer · 2016-07-05 23:34:41Z

0

You probably use Laravel, so this package it integrated:

https://github.com/briannesbitt/Carbon

And try this tutorial to get up to speed:

https://scotch.io/tutorials/easier-datetime-in-laravel-and-php-with-carbon

answered Jul 5, 2016 at 23:34

Igor T.

294 bronze badges

Collectives™ on Stack Overflow

php timestamp to readable date not working as expected

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related