我想数据库的Date类型的字段只显示年月日,不显示00:00:00时分秒,请问怎么处理?

Question

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE mapperPUBLIC "-//mybatis.org//DTD mapper 3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mapper namespace="com.cn.dao.NewOperDaoMapper"><!-- 发布新闻 --><insert id="addNews">insert into NEWS(TITLE,CONTENT,RELEASETIME,AUTHOR) values(#{newsTitle},#{content},to_date(#{realeaseDate},'yyyy-MM-dd'),#{authorName})</insert></mapper>请问to_date(#{realeaseDate},'yyyy-MM-dd') 这样写错在哪里吗?

Answer 1

trunc(#{realeaseDate})

Answer 2

trunc(to_date(#{realeaseDate},'yyyy-MM-dd'))试试...