不知道我应该使用什么日期类型的声明

CREATE TABLE players(   id INT,     birthdate DATE,     PRIMARY KEY(id) );

SELECT * FROM players WHERE DATE-birthdate > 40;
CREATE TABLE players(   id INT,     birthdate D