select FINA_ID AS finaId,
START_DATE AS startDate,
END_DATE AS endDate,
REMIND_DAYS AS remindDays
from t09_zj_fina_prod_info fina
where fina.VALID_STATUS = "1"
<if test="startDate != null and endDate == null" >
and fina.START_DATE >= #{beginDate}
//区间[startDate,+无穷]
</if>
<if test="startDate == null and endDate != null">
and fina.END_DATE <= #{finishDate}
//区间[负无穷,endDate]
</if>
<if test="startDate != null and endDate != null">
and fina.START_DATE >= #{beginDate} and fina.END_DATE <= #{finishDate}
//[startDate,endDate]
</if>
根据日期区间查询sql
最新推荐文章于 2024-07-31 21:32:36 发布