postgresql 之 mybatis 按日期查询 

日期格式
YYYY-MM-DD HH24:MI

转换为字符的函数 to_char(字段名, 日期格式)


<if test="null != repm.startReleaseTime and '' != repm.startReleaseTime.trim() and null != repm.endReleaseTime and '' != repm.endReleaseTime.trim()">
            AND to_char( a.register_time, 'YYYY-MM-DD HH24:MI' ) BETWEEN #{ repm.startReleaseTime } AND #{ repm.endReleaseTime }
        </if>
posted @ 2025-01-16 23:59  hapday  阅读(105)  评论(0)    收藏  举报