to_date(#{pd.lastUpdateEnd},'yyyy-MM-dd')
比如:
<!-- 更新时间检索 -->
<if test="pd.lastUpdateStart!=null and pd.lastUpdateStart!=''">
and PRODUCT_RELEASE_DATE >=
to_date(#{pd.lastUpdateStart},'yyyy-MM-dd')
</if>
<if test="pd.lastUpdateEnd!=null and pd.lastUpdateEnd!=''">
and PRODUCT_RELEASE_DATE <=
to_date(#{pd.lastUpdateEnd},'yyyy-MM-dd')
</if>
< 是小于,> 是大于,