1
drop table if exists t1;
2
create table t1 (y year,y2 year(2));
3
insert into t1 values (0,0),(1999,1999),(2000,2000),(2001,2001),(70,70),(69,69);
12
select * from t1 order by y;
20
select * from t1 order by y2;
29
create table t1 (y year);
30
insert into t1 values (now());
32
Warning 1265 Data truncated for column 'y' at row 1
33
select if(y = now(), 1, 0) from t1;
37
create table t1(a year);
38
insert into t1 values (2000.5), ('2000.5'), ('2001a'), ('2.001E3');
40
Warning 1265 Data truncated for column 'a' at row 3