如何在 Java 中将日历转换为 java.sql.Date? [英] How to convert Calendar to java.sql.Date in Java?

问题描述

Calendar cal;
String sql = "INSERT INTO ttable (dt) values (?);"
//dt is a dateTime field in ttable

PreparedStatement stmt = connection.prepareStatement(sql);

stmt = setDate(1,cal); //not working

stmt.execute();
stmt.close();

我想将 cal 转换为 Date 类型以插入到表格中.

I would like to convert cal to a Date type to insert into table.

推荐答案

有一个getTime() 方法(不确定为什么不叫 getDate).

There is a getTime() method (unsure why it's not called getDate).

刚刚意识到您需要一个 java.sql.Date.使用 cal.getTimeInMillis() 的答案之一就是您所需要的.

Just realized you need a java.sql.Date. One of the answers which use cal.getTimeInMillis() is what you need.

这篇关于如何在 Java 中将日历转换为 java.sql.Date?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！