oracle 时间段查询

MyBatis SQL查询示例

最新推荐文章于 2025-09-09 20:40:49 发布

转载最新推荐文章于 2025-09-09 20:40:49 发布 · 59 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/aGboke/p/8934516.html

文章标签：

#数据库 #java

<select id="selectByRzrq" resultMap="BaseResultMap" parameterType="java.util.HashMap" >
  select 
  <include refid="Base_Column_List" />
  from T_AUCHAN_VAT_MAIN
  where BUYTAXNO = #{buytaxno}  AND  INVSTATUS='3' AND  CANCELSIGN='0'
  <if test="starttime != null and starttime != '' and endtime != null and endtime != ''">
    <![CDATA[
      AND INVVERIDATE >= TO_DATE(#{starttime}, 'yyyy-mm-dd')
      AND INVVERIDATE <= TO_DATE(#{endtime}, 'yyyy-mm-dd')
 ]]>
  </if>

</select>