34,588
社区成员
发帖
与我相关
我的任务
分享
SELECT * FROM tb
WHERE DATEDIFF(yy,'1990-1-1',birthday)>=0
select * from table where DATEPART(YEAR,生日字段) > 1989
select * from table where 生日字段 >='1990-01-01'
select * from TB where Year(生日字段) > 1989
select * from tb where birthday >='1990-01-01 00:00:00'
select * from tb where birthday >='1900-01-01 00:00:00'
select * from tb where year(birthday) > 1989