DataTime数据库类型 数据新增失败

来源:互联网 发布:看报纸的软件 编辑:程序博客网 时间:2024/04/28 22:29
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException: ### Error updating database.  Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '08:57:57' for column 'noticeTime' at row 1### The error may involve com.ht.mapper.official.NoticeMapper.UpdateNoticeInfo-Inline### The error occurred while setting parameters### SQL: UPDATE `days_notice` SET noticetypeid = ?,title = ?,content = ?,empid = ?,noticeTime = ?,remark= ? WHERE id = ?### Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '08:57:57' for column 'noticeTime' at row 1; SQL []; Data truncation: Incorrect datetime value: '08:57:57' for column 'noticeTime' at row 1; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '08:57:57' for column 'noticeTime' at row 1org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:927)org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:822)javax.servlet.http.HttpServlet.service(HttpServlet.java:650)org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:796)javax.servlet.http.HttpServlet.service(HttpServlet.java:731)org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

org.apache.logging.log4j.core.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:66)

问题:时间格式不匹配 数据库中Datatime的格式为 YYYY-MM-DD hh:mm:ss.0

解决办法:new Date().toLocaleString() 可用

0 0