将java日期转换为Sql时间戳 [英] Converting java date to Sql timestamp

问题描述

我正在尝试插入 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时间戳的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！