红警亚太核战争秘籍:判断时间差为何显示不了结果?

来源:百度文库 编辑:神马品牌网 时间:2024/04/29 09:17:47
rs.open"select sum(case sex when '男' then 1 else 0 end) as m,sum(case sex when '女' then 1 else 0 end) as w from yuangong where datediff(year,shengri,"&date&")>=36 and datediff(year,shengri,"&date&")<=45",conn,1,1
我是想查询年龄在36-45之间的员工人数,shengri为员工的生日字段格式是yyyy-m-d
我用上面的语句,可没有任何结果,也没有报错,这是怎么回事?