How to convert a 13 digit Unix Timestamp to Date and time?

Question

I have this 13 digit timestamp 1443852054000 that i want to convert to date and time but dont succeed. I have tried this codes:

echo date('Y-m-d h:i:s',$item->timestamp);

doesnt work for me and also this

$unix_time = date('Ymdhis', strtotime($datetime ));

and this :

$item = strtotime($txn_row['appoint_date']); 
<?php echo date("Y-m-d H:i:s", $time); ?>

what should i use?

it's in milliseconds. just remove the last three zeros and your code will work. — John Conde, Oct 03 '15 at 19:44

score 48 · Accepted Answer · edited Aug 28 '19 at 14:12

48

This timestamp is in milliseconds, not in seconds. Divide it by 1000 and use date function:

echo date('Y-m-d h:i:s', $item->timestamp / 1000);
// e.g
echo date('Y-m-d h:i:s',1443852054000/1000);
// shows 2015-10-03 02:00:54

edited Aug 28 '19 at 14:12

Wez

10,267
5
48
63

answered Oct 03 '15 at 19:43

u_mulder

53,091
5
44
59

2

i am still getting this result 1970-01-01 01:00:00 – glendon philipp Baculio Oct 03 '15 at 19:45
`var_dump($item->timestamp);` – u_mulder Oct 03 '15 at 19:46
I can't say why is it null. You have to check it yourself. – u_mulder Oct 03 '15 at 19:50
I think, the divided timestamp should be rounded (to provide date() with an int). – jasie May 10 '20 at 19:21

score 5 · Answer 2 · edited Feb 28 '19 at 08:24

5

A 13 digit timestamp is used in JavaScript to represent time in milliseconds. In PHP 10 a digit timestamp is used to represent time in seconds. So divide by 1000 and round off to get 10 digits.

$timestamp = 1443852054000;
echo date('Y-m-d h:i:s', floor($timestamp / 1000));

edited Feb 28 '19 at 08:24

karel

4,637
41
42
47

answered Feb 28 '19 at 07:57

santhosh

51
1
1

great answer bro, Thanks. – vahid sabet Jul 21 '20 at 13:16

Pedro Lobito · Answer 3 · 2015-10-03T20:10:56.660

You can achieve this with DateTime::createFromFormat.

Because you've a timestamp with 13 digits, you'll have to divide it by 1000, in order to use it with DateTime, i.e.:

$ts = 1443852054000 / 1000; // we're basically removing the last 3 zeros
$date = DateTime::createFromFormat("U", $ts)->format("Y-m-d h:i:s");
echo $date;
//2015-10-03 06:00:54

DEMO

http://sandbox.onlinephpfunctions.com/code/d0d01718e0fc02574b401e798aaa201137658acb

You may want to set the default timezone to avoid any warnings

date_default_timezone_set('Europe/Lisbon');

NOTE:

More about php date and time at php the right way

Tell that to Zuckerberg – Pedro Lobito Mar 18 '18 at 11:25 — Pedro Lobito, Mar 18 '18 at 11:25

How to convert a 13 digit Unix Timestamp to Date and time?

3 Answers3

Linked

Related