17,078
社区成员
发帖
与我相关
我的任务
分享
select * from BC_BCOA_PERSON WHERE PERSON_ID != 0 and PERSON_DELETE=0 and(YEAR (CURDATE()) -1 - YEAR (PERSON_BIRTHDAY) + (DATE_FORMAT(PERSON_BIRTHDAY,'%m%d') <= (DATE_FORMAT(CURDATE(), '%m%d'))))>=20 AND (YEAR (CURDATE()) -1 - YEAR (PERSON_BIRTHDAY) + (DATE_FORMAT(PERSON_BIRTHDAY, '%m%d') <= (DATE_FORMAT(CURDATE(), '%m%d'))))<=100