Page 1 of 1

Date problem

Posted: Sat Jun 21, 2014 3:03 am
by barb woolums
I am selecting a unix time from a mysql database which is 4094946000 - I used an online converter and this timestamp converts to Tue, 06 Oct 2099 05:00:00 GMT

I then use

Code: Select all

$date = 4094946000;
$date = date('d/m/Y',$date);
...and I get 30/08/1963 - what am I doing wrong?

Re: Date problem

Posted: Sat Jun 21, 2014 7:12 am
by requinix
On a 32-bit system, 409494600 is actually -200021296. You need a 64-bit system to get dates past 2038.

Re: Date problem

Posted: Sat Jun 21, 2014 7:29 pm
by barb woolums
Thanks