mysql allow invalid dates on select

Question

For some reason, I can't even select invalid dates in my table. How do I force select? I just receive:

select * from table
>> Mysql2::Error: Invalid date: 1900-00-00

I'm not trying to insert, just select. Can I set allow invalid dates in select query?

mysql --version
mysql  Ver 14.14 Distrib 5.1.61, for debian-linux-gnu (i686) using readline 6.1

mysql> select @@global.sql_mode;
+-------------------+
| @@global.sql_mode |
+-------------------+
|                   |

Answer 1

This is what I do to ignore invalid dates:

SET SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';

Answer 2

• Log into mysql in the command line mysql -u root -p
• Enter your password
• View the current sql-modes using SELECT @@GLOBAL.sql_mode;
• Copy the current modes (add or delete modes as needed) and paste in next step.
• Set the sql-modes using SET GLOBAL sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,ALLOW_INVALID_DATES';
• This adds ALLOW_INVALID_DATES and removes both NO_ZERO_DATE, NO_ZERO_IN_DATE
• Restart the MySQL server /etc/init.d/mysql start