drop table if exists t1;
|
create table t1 (a int);
|
insert into t1 values (0);
|
select last_day(a), last_day(0) from t1;
|
+-------------+-------------+
|
| last_day(a) | last_day(0) |
|
+-------------+-------------+
|
| NULL | NULL |
|
+-------------+-------------+
|
1 row in set, 1 warning (0.00 sec)
|
|
show warnings;
|
+---------+------+-------------------------------+
|
| Level | Code | Message |
|
+---------+------+-------------------------------+
|
| Warning | 1292 | Incorrect datetime value: '0' |
|
+---------+------+-------------------------------+
|