java 解决mapper查询数据库时间字段秒后多出.0问题

DATE_FORMAT(时间字段, ‘%Y-%m-%d %k:%i:%s’)针对数据库如果是dateTime型字段传前台最好sql这样处理一下否则会出现x.xx.xx.0这种现象<select id="selectLogByShow" resultType="map">SELECTDATE_FORMAT(new_date, '%Y-%m-%d %k:%i:%s')as newDate

撸铁和键盘

969人浏览 · 2020-07-14 16:39:48

撸铁和键盘 · 2020-07-14 16:39:48 发布

DATE_FORMAT(时间字段, ‘%Y-%m-%d %k:%i:%s’)针对数据库如果是dateTime型字段
传前台最好sql这样处理一下否则会出现x.xx.xx.0这种现象

<select id="selectLogByShow" resultType="map">
        SELECT
            DATE_FORMAT(new_date, '%Y-%m-%d %k:%i:%s')as newDate,
            DATE_FORMAT(update_start, '%Y-%m-%d %k:%i:%s') as updateStart,
            DATE_FORMAT(update_new_start, '%Y-%m-%d %k:%i:%s') as updateNewStart,
            DATE_FORMAT(update_end, '%Y-%m-%d %k:%i:%s') as  updateEnd,
            DATE_FORMAT(update_new_date, '%Y-%m-%d %k:%i:%s') as updateNewDate
        FROM
            license_message_log
        WHERE
            license_id=#{licenseId}
        <if test="theagentId != null and theagentId !=1 ">
            and login_id=#{loginId}
        </if>
        ORDER BY log_id DESC
    </select>