每日一课 | Java 8 中 ZonedDateTime 与 Timestamp 的相互转换

将java.time.ZonedDateTime转换为java.sql.Timestamp Java示例，反之亦然。

1. ZonedDateTime->时间戳

TimeExample1.java 

package com.mkyong.jdbc; import java.sql.Timestamp;
import java.time.ZonedDateTime;public class TimeExample1 {public static void main(String[] args) {ZonedDateTime now = ZonedDateTime.now();// 1. ZonedDateTime to TimeStampTimestamp timestamp = Timestamp.valueOf(now.toLocalDateTime());// 2. ZonedDateTime to TimeStamp , no differentTimestamp timestamp2 = Timestamp.from(now.toInstant());System.out.println(now); // 2019-06-19T14:12:13.585294800+08:00[Asia/Kuala_Lumpur]System.out.println(timestamp); // 2019-06-19 14:12:13.5852948System.out.println(timestamp2); // 2019-06-19 14:12:13.5852948}
}

输出量

2019-06-19T14:12:13.585294800+08:00[Asia/Kuala_Lumpur]
2019-06-19 14:12:13.5852948
2019-06-19 14:12:13.5852948

2.时间戳-> ZonedDateTime

TimeExample2.java 

package com.mkyong;import java.sql.Timestamp;
import java.time.Instant;
import java.time.LocalDateTime;
import java.time.ZoneId;
import java.time.ZonedDateTime;public class TimeExample2 {public static void main(String[] args) {Timestamp timestamp = Timestamp.from(Instant.now());LocalDateTime localDateTimeNoTimeZone = timestamp.toLocalDateTime();ZonedDateTime zonedDateTime1 = localDateTimeNoTimeZone.atZone(ZoneId.of("+08:00"));ZonedDateTime zonedDateTime2 = localDateTimeNoTimeZone.atZone(ZoneId.of("Asia/Kuala_Lumpur"));ZonedDateTime zonedDateTime3 = localDateTimeNoTimeZone.atZone(ZoneId.systemDefault());ZonedDateTime zonedDateTime4 = localDateTimeNoTimeZone.atZone(ZoneId.of("-08:00"));System.out.println(timestamp); // 2019-06-19 14:08:23.4458984System.out.println(zonedDateTime1); // 2019-06-19T14:08:23.445898400+08:00System.out.println(zonedDateTime2); // 2019-06-19T14:08:23.445898400+08:00[Asia/Kuala_Lumpur]System.out.println(zonedDateTime3); // 2019-06-19T14:08:23.445898400+08:00[Asia/Kuala_Lumpur]System.out.println(zonedDateTime4); // 2019-06-19T14:08:23.445898400-08:00}}

输出量

2019-06-19 14:08:23.4458984
2019-06-19T14:08:23.445898400+08:00
2019-06-19T14:08:23.445898400+08:00[Asia/Kuala_Lumpur]
2019-06-19T14:08:23.445898400+08:00[Asia/Kuala_Lumpur]
2019-06-19T14:08:23.445898400-08:00

参考文献

• Java 8 –将LocalDateTime转换为时间戳

• ZonedDateTime JavaDocs

• LocalDateTime JavaDocs

• 时间戳记JavaDocs

翻译自: https://mkyong.com/java8/java-8-convert-zoneddatetime-to-timestamp/

推荐阅读--

每日一课 | Python-气泡图

每日一课 | 如何将int转换为String

每日一课 | Python-箱线图

每日一课 | Python综合案例实战

每日一课 | 如何在函数中使用全局变量

球分享球点赞球在看