gnu/linux 64 bit with #mysql x86_64 will still break in #2038

gnu/linux 64 bit with mysql x86_64 will still break in 2038

SELECT UNIX_TIMESTAMP('2038-01-01'),UNIX_TIMESTAMP('2039-01-01'),UNIX_TIMESTAMP('2040-01-01');
+------------------------------+------------------------------+------------------------------+
| UNIX_TIMESTAMP('2038-01-01') | UNIX_TIMESTAMP('2039-01-01') | UNIX_TIMESTAMP('2040-01-01') |
+------------------------------+------------------------------+------------------------------+
|                   2145916800 |                            0 |                            0 |
+------------------------------+------------------------------+------------------------------+
1 row in set (0.01 sec)

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s