PHP, Converting timestamp to a date

Question

From an external website I receive, amongst other data, a date/time stamp like this 1346729259806 or 1346734102948 I have been trying to see what the best way to convert this into a formatted date/time readable for later use.

I found out that the timestamp is Epoch format in miliseconds. Is there a regular way to convert this?

Many thanks in advance

possible duplicate of Converting a UNIX Timestamp to Formatted Date String — John Carter
– John Carter, Commented Sep 4, 2012 at 3:34

xdazz · Accepted Answer · 2012-09-04 03:33:41Z

6

date() function takes the second parameter as the timestamp.

echo date('Y-m-d H:i:s', 1346729259806/1000);

answered Sep 4, 2012 at 3:33

xdazz

161k38 gold badges255 silver badges278 bronze badges

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

1 Comment

Muneeb Mirza Over a year ago

i was sending from Android to php and it wasnt converting. Then i saw your "/1000" xD

jonsca · Accepted Answer · 2012-09-04 08:28:10Z

0

You can convert the timestamp to date in mysql by using DATE and FROM_UNIXTIME function. The command given bellow,

FROM_UNIXTIME
SELECT create FROM phpkit ;

The output created:

1216053466

Then:

SELECT DATE( FROM_UNIXTIME( `created` ) ) AS pDate FROM phpkit

Output:

2008-07-14

I found the source from the following link.

edited Sep 4, 2012 at 8:28

jonsca

10.5k26 gold badges56 silver badges63 bronze badges

answered Sep 4, 2012 at 4:13

vandu

1961 gold badge4 silver badges17 bronze badges

Collectives™ on Stack Overflow

PHP, Converting timestamp to a date

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related