How can I convert timestamp of year 2038 to date in php

Question

Possible Duplicate:
PHP & mySQL: Year 2038 Bug: What is it? How to solve it?

I met problem when converts timestamp (of year of 2038 or above) to date in PHP, it always shows year of 1901 instead 2038 or above. But everything works correctly when converts timestamp of year < 2038. Please help me to solve this problem. Thank you very much!

NullPoiиteя · Accepted Answer · 2012-10-12T02:13:06.107

1

its because of the limit of INT datatype on 32 bit machine

enter image description here

Solution

Use long data types (64 bits is sufficient)
For MySQL, store dates as DATETIME rather than TIMESTAMP

edited Oct 12 '12 at 02:13

answered Oct 12 '12 at 01:55

NullPoiиteя

56,591
22
125
143

Thank you for answering. But Is there any solution on 32 bit machine. – Nguyen Minh Tuan Oct 12 '12 at 02:06
@Tuan Use long data types (64 bits is sufficient)and For MySQL, store dates as DATETIME rather than TIMESTAMP – NullPoiиteя Oct 12 '12 at 02:08
wow.. your solution #1 and #2 are complete copy-paste from the other [answer](http://stackoverflow.com/questions/2012589/php-mysql-year-2038-bug-what-is-it-how-to-solve-it). – tradyblix Oct 12 '12 at 02:23

How can I convert timestamp of year 2038 to date in php

1 Answers1

Linked