sql server 范围时间查询_sqlserver 时间范围查询关键字

  <select id="getFpw" resultType="java.util.Map">
      SELECT  ISNULL(num,0)as num  ,rTime FROM fpw WHERE rTime BETWEEN  CONVERT(varchar(100), #{startDay}, 20) and CONVERT(varchar(100),   #{endDay}, 20) and rFirm = #{firm} and rBumen =#{bumen} AND rZu = #{zu}
    </select>

    <select id="getFpwMonth" resultType="integer">
       SELECT  ISNULL(cast(SUM(num) as varchar),0)  FROM fpw WHERE datediff(month,[rTime],#{Date})=0 and rFirm = #{firm} and rBumen =#{bumen} AND rZu = #{zu}
    </select>

    <select id="getFpwYear" resultType="integer">
       SELECT  ISNULL(cast(SUM(num) as varchar),0)  FROM fpw WHERE datediff(year,[rTime],#{Date})=0 and rFirm = #{firm} and rBumen =#{bumen} AND rZu = #{zu}
    </select>
1
2
3
4
5
6
7
8
9
10
11

数据库