unix timestamp conversion results not accurate php

Question

I am trying to convert a unix timestamp into readable text. The timestamp is stored in a database and shown in a table. The problem is the results are not accurate.

Code:

<td>'.date("F j, Y, g:i a", strtotime($row['expire'])).'</td>

database:

enter image description here

Result:

enter image description here

@Evan Mulawski i update my question to show expire

Daniel
– Daniel

2012-06-16 00:12:04 +00:00
Commented Jun 16, 2012 at 0:12 — Daniel
– Daniel, Commented Jun 16, 2012 at 0:12

Niet the Dark Absol · Accepted Answer · 2012-06-16 00:13:04Z

3

Two options:

Remove the strtotime call, since you already have the timestamp as a number, OR
Change the database field to TIMESTAMP.

answered Jun 16, 2012 at 0:13

Niet the Dark Absol

326k86 gold badges480 silver badges604 bronze badges

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

Collectives™ on Stack Overflow

unix timestamp conversion results not accurate php

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related