本文介绍了将java日期转换为Sql时间戳的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在尝试插入 java.util.Date ,将其转换为java.sql.Timestamp,并使用以下代码段:
I am trying to insert java.util.Date after converting it to java.sql.Timestamp and I am using the following snippet:
java.util.Date utilDate = new java.util.Date(); java.sql.Timestamp sq = new java.sql.Timestamp(utilDate.getTime());但这是给我 sq as 2014-04-04 13:30:17.533
有没有办法得到输出毫秒?您可以使用 Calendar c
Is there any way to get the output without milliseconds?
推荐答案
You can cut off the milliseconds using a Calendar:
java.util.Date utilDate = new java.util.Date(); Calendar cal = Calendar.getInstance(); cal.setTime(utilDate); cal.set(Calendar.MILLISECOND, 0); System.out.println(new java.sql.Timestamp(utilDate.getTime())); System.out.println(new java.sql.Timestamp(cal.getTimeInMillis()));输出:
2014-04-04 10:10:17.78 2014-04-04 10:10:17.0更多推荐
将java日期转换为Sql时间戳
发布评论