MySQL允许选择无效的日期 [英] mysql allow invalid dates on select

问题描述

由于某种原因，我什至无法在表格中选择无效的日期.如何强制选择?我刚收到:

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 |
+-------------------+
|                   |

推荐答案

这是我忽略无效日期的方法:

This is what I do to ignore invalid dates:

SET SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';

这篇关于MySQL允许选择无效的日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！