year 2038 issue - 64 bit (Linux OS, php, mysql)
<p><code>select unix_timestamp('2038-01-19')</code> returns <code>2147472000</code></p>

<p>while <code>select unix_timestamp('2038-01-20')</code> returns <code>0</code></p>

<p>I have checked out the year <code>2038</code> problem.</p>

<p>My linux OS is 64 bit and installed mysql version is also 64 bits. What is the solution to this problem now?</p>

<p><code>mysql --version</code> returns <code>mysql  Ver 14.14 Distrib 5.5.47, for Linux (x86_64) using readline 5.1
</code><br>
Php is 64 bit too.</p>

<p>Tried BigInt too, didn't work (returns the same thing).</p>