How to get datetime data in mysql, followed by .0

The data type of MySQL is datetime. The data stored in the database is 2015-01-19 05:02:02. When it is transferred to Java, it becomes 2015-01-19 05:02:02.0, with an extra .0 at the end.

The display format can be formatted by the following centralized method:

1. The type of regtime must be date type to be used in this way, which can be achieved through jstl

<%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt" %>
<fmt:formatDate value="${userDb.regtime}" pattern="yyyy-MM-dd HH:mm:ss"/>

2. The type of regtime is String, which is implemented by js

<div><script>document.write("${userDb.regtime}".substring(0, 19));</script></div>

3. The type of regtime is String, which is implemented by jstl

<%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions" %>
<div>${fn:substring(userDb.regtime, 0, 19)}</div>

Display results: 2015-01-19 05:02:02

The above article about how to obtain datetime type data in MySQL, followed by a .0 implementation method, is all I have to share with you. I hope it can give you a reference. I also hope that you will support 123WORDPRESS.COM.