这里展示的是一个单表的关于日期区间查询的一个SQL
框架是springboot+mybaitsplus
数据库用的oracle
具体代码如下:
SELECT * FROM PR_T_USER_PUNCH_CARD WHERE 1=1
<if test="userCode != null and userCode != ''">
AND USER_CODE = #{userCode}
</if>
<if test="beforeTime != null and beforeTime != '' and endTime != null and endTime != ''">
AND to_char(PUNCH_TIME,'yyyy-mm-dd') between #{beforeTime} and #{endTime}
</if>