PGSql-PostGresql数据库操作

常用sql语句函数

日期字符串使用

// 时间戳和字符串比较 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>
//字符串转时间
select to_timestamp(string, 'yyyy-mm-dd hh24:MI:SS')

日期提取年

      <if test="param.inSchoolYearVal != null">
            AND EXTRACT(YEAR FROM kxsj) = #{param.inSchoolYearVal}
        </if>