Re: Unexpected Data truncated for Date

[Peter Brawley]

Arggh, d_calcdate and d_birthdate are INTs.

drop table if exists t;
create table t(d int);
insert into t values(1872-12-13),('1872-12-13');
Warning (Code 1265): Data truncated for column 'd' at row 1
select * from t;
+------+
| d    |
+------+
| 1847 |
| 1872 |
+------+

Store dates in DATE columns.