关于sql语句中表达式的问题

xflion

写了一个检索年龄段为未成年的sql语句
select a.id,a.tele,a.mobile,year(today)-year(bthdate) as age from a
where month(bthdate)=month(today)
and day(bthdate)=day(today)
要检索今天过生日，而且age<16岁的，这个条件怎么加啊?

wenlq

再加个条件 year(today) - year(bthdate) < 16
或者 bthdate >= '1/1/1990'

lmtok

and bthdate < today - 16 units year

yunzhongyue

and month(bthdate)||day(bthdate)=month(today)||day(today)   -- 今天过生日