Shulou(Shulou.com)06/01 Report--

This article is about how mysql removes the millisecond value. The editor thought it was very practical, so I shared it with you as a reference. Let's follow the editor and have a look.

Mysql to remove the millisecond value method: 1, through the "public static Timestamp getSystemTime () {...}" method to remove the millisecond value; 2, through the use of JSTL to remove the millisecond value.

Read the timestamp type in the database and remove milliseconds

The query time in the database is: 2015-09-24 14-14-30-26. 2, with milliseconds, and needs to be removed.

Method 1:

Public static Timestamp getSystemTime () {Date dt = new Date (); DateFormat df = new SimpleDateFormat ("yyyy-MM-dd HH:mm:ss"); String nowTime = df.format (dt); java.sql.Timestamp buydate = java.sql.Timestamp.valueOf (nowTime); return buydate;}

Method 2:

-if the Web client needs to be used, it is recommended to use JSTL-. Thank you for reading! On the mysql to remove the millisecond value of the method to share here, I hope the above content can be of some help to you, so that you can learn more knowledge. If you think the article is good, you can share it and let more people see it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.