MariaDB [test]> drop table if exists t1; create table t1 (a timestamp); insert into t1 values (timestamp('2001-00-01 00:00:00.9999999')); show warnings; select * from t1;
|
Query OK, 0 rows affected (0.07 sec)
|
Query OK, 0 rows affected (0.19 sec)
|
Query OK, 1 row affected, 3 warnings (0.04 sec)
|
+---------+------+-------------------------------------------------------------------+
|
| Level | Code | Message |
|
+---------+------+-------------------------------------------------------------------+
|
| Warning | 1292 | Truncated incorrect datetime value: '2001-00-01 00:00:00.9999999' |
|
| Warning | 1265 | Data truncated for column 'a' at row 1 |
|
| Warning | 1292 | Truncated incorrect datetime value: '2001-00-01 00:00:00.9999999' |
|
+---------+------+-------------------------------------------------------------------+
|
3 rows in set (0.00 sec)
|
+---------------------+
|
| a |
|
+---------------------+
|
| 0000-00-00 00:00:00 |
|
+---------------------+
|
1 row in set (0.00 sec)
|