很急呀，在线等待

Question

答对了的，也请到http://expert.csdn.net/Expert/topic/1592/1592467.xml?temp=.3084528
接分

Answer 1

SELECT *
FROM jgw_ageofficer
WHERE datediff(yy,convert(datetime,birthday,120) ,convert(datetime,'2003-02-01',120  )) < 80

Answer 2

SELECT *
FROM jgw_ageofficer
WHERE DATEDIFF(yy,convert(datetime,birthday,112),'2004-02-01') < 80

Answer 3

SELECT *
FROM jgw_ageofficer
WHERE datediff(yy,'birthday',getdate())) < 80
是返回<80的数据呀

Answer 4

SELECT *
FROM jgw_ageofficer
WHERE datediff(yy,convert(datetime,birthday,120) ,convert(datetime,getdate(),120  )) < 80SELECT *
FROM jgw_ageofficer
WHERE datediff(yy,birthday,'2003-02-01') < 80SELECT *
FROM jgw_ageofficer
WHERE datediff(yy,birthday,getdate()) < 80