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

Question

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//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'))试试...