То си пише ама някой трябва да чете ...

mysql> CREATE TABLE d (d DATE);
Query OK, 0 rows affected (0.03 sec)

mysql> INSERT INTO d VALUES('2006-02-30');
Query OK, 1 row affected, 1 warning (0.00 sec)

mysql> SHOW WARNINGS;
+---------+------+----------------------------------------+
| Level | Code | Message |
+---------+------+----------------------------------------+
| Warning | 1265 | Data truncated for column 'd' at row 1 |
+---------+------+----------------------------------------+

mysql> SET SQL_MODE=TRADITIONAL;
Query OK, 0 rows affected (0.00 sec)

mysql> INSERT INTO d VALUES('2006-02-30');
ERROR 1292 (22007): Incorrect date value: '2006-02-30' for column 'd' at row 1

Съдържаниет е скрито
Влезте за да го видите