将LocalDate转换为LocalDateTime或java.sql.Timestamp [英] Convert LocalDate to LocalDateTime or java.sql.Timestamp

问题描述

我正在使用JodaTime 1.6.2。

I am using JodaTime 1.6.2.

我有一个 LocalDate 我需要转换为a（Joda） LocalDateTime ，或 java.sqlTimestamp 用于ormapping。

I have a LocalDate that I need to convert to either a (Joda) LocalDateTime, or a java.sqlTimestamp for ormapping.

原因是我已经想出如何在 LocalDateTime 和 java.sql.Timestamp ：

The reason for this is I have figured out how to convert between a LocalDateTime and a java.sql.Timestamp:

LocalDateTime ldt = new LocalDateTime();
DateTimeFormatter dtf = DateTimeFormatter.forPattern("yyyy-MM-dd HH:mm:ss");
Timestamp ts = Timestamp.valueOf(ldt.toString(dtf));

所以，如果我只能在 LocalDate 和 LocalDateTime ，然后我可以继续转换为 java.sql.Timestamp 。感谢你在正确方向上的任何推动！

So, if I can just convert between LocalDate and LocalDateTime, then I can make the continued conversion to java.sql.Timestamp. Thanks for any nudges in the right direction!

推荐答案

JodaTime

转换JodaTime的 org.joda.time。 LocalDate java.sql.Timestamp ，只需执行

JodaTime

To convert JodaTime's org.joda.time.LocalDate to java.sql.Timestamp, just do

Timestamp timestamp = new Timestamp(localDate.toDateTimeAtStartOfDay().getMillis());

转换JodaTime的 org.joda.time.LocalDateTime 到 java.sql.Timestamp ，只需执行

To convert JodaTime's org.joda.time.LocalDateTime to java.sql.Timestamp, just do

Timestamp timestamp = new Timestamp(localDateTime.toDateTime().getMillis());

---

JavaTime

转换Java8的 java.time.LocalDate 到 java.sql.Timestamp ，只需执行

---

JavaTime

To convert Java8's java.time.LocalDate to java.sql.Timestamp, just do

Timestamp timestamp = Timestamp.valueOf(localDate.atStartOfDay());

转换Java8的 java.sql.Timestamp ，只需执行

To convert Java8's java.time.LocalDateTime to java.sql.Timestamp, just do

Timestamp timestamp = Timestamp.valueOf(localDateTime);

这篇关于将LocalDate转换为LocalDateTime或java.sql.Timestamp的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！