date() expects parameter 2 to be integer, float given

I got the following timestamp long value from database 147836340000 and I want to convert it on data and time. I have tried to use the following:

$timestamp=147836340000;
print_r(date('m/d/Y H:i:s', $timestamp));

But unfortunately I am getting the following error:

date() expects parameter 2 to be integer, float given

Please advice on what I need to do.

Answer

It’s probably JS timestamp, so you need to divide it by 1000. But in your example, the date looks off by one extra 0 at the end. It should be 1478363400000 according to JS specs.

Your version:

$timestamp=147836340000;
print_r(date('m/d/Y H:i:s', $timestamp));
> 09/30/6654 18:00:00

Try this one (Online Demo):

$timestamp=(int) 147836340000 / 1000;
echo "Wrong: " . date('m/d/Y H:i:s', $timestamp) . PHP_EOL;

$timestamp=(int) 1478363400000 / 1000;
echo "Corrected: " . date('m/d/Y H:i:s', $timestamp) . PHP_EOL;

> Wrong: 09/08/1974 02:39:00
> Corrected: 11/05/2016 17:30:00

More details can be found here: Timestamp between Javascript and PHP