将java.time.instant转换为没有区域偏移量的java.sql.timestamp

Question

Instant now = Instant.now();

Timestamp current = Timestamp.from(now);

当我这样创作的时候：

LocalDateTime ldt = LocalDateTime.ofInstant(Instant.now(), ZoneOffset.UTC);
Timestamp current = Timestamp.valueOf(ldt);

一切都工作得很好，但我尽量避免转换。是否可以通过只使用instant对象来实现这一点？

Answer 1

我把电脑的时区改为欧洲/布加勒斯特做实验。这是UTC+2小时，就像你的时区一样。

现在，当我复制您的代码时，我得到了一个类似于您的结果：

    Instant now = Instant.now();
    System.out.println(now); // prints 2017-03-14T06:16:32.621Z
    Timestamp current = Timestamp.from(now);
    System.out.println(current); // 2017-03-14 08:16:32.621

输出在注释中给出。然而，我继续说：

    DateFormat df = DateFormat.getDateTimeInstance();
    df.setTimeZone(TimeZone.getTimeZone("UTC"));
    // the following prints: Timestamp in UTC: 14-03-2017 06:16:32
    System.out.println("Timestamp in UTC: " + df.format(current));

    LocalDateTime ldt = LocalDateTime.ofInstant(Instant.now(), ZoneOffset.UTC);
    System.out.println(ldt); // 2017-03-14T06:16:32.819
    current = Timestamp.valueOf(ldt);
    System.out.println(current); // 2017-03-14 06:16:32.819
    System.out.println("Timestamp in UTC: " + df.format(current)); // 14-03-2017 04:16:32