Kotlin LocalDateTime为长[重复]

Question

我正在尝试将LocalDateTime字段保存为long，以便将其存储在SQLite数据库中。我怎么能做到这一点？

var datetime = LocalDateTime.now()
var longdt: Long = getString(datetime).toLong()

Answer 1

可以使用ToEpochSecond()和OfePochSecond()将Long值精确到秒。

示例（Java）

LocalDateTime now = LocalDateTime.now();
long nowInSeconds = now.toEpochSecond(ZoneOffset.UTC);
LocalDateTime dateTime = LocalDateTime.ofEpochSecond(nowInSeconds, 0, ZoneOffset.UTC);

System.out.println("now = " + now);
System.out.println("nowInSeconds = " + nowInSeconds);
System.out.println("dateTime = " + dateTime);

输出

now = 2020-05-12T12:12:36.984263200
nowInSeconds = 1589285556
dateTime = 2020-05-12T12:12:36

LocalDateTime now = LocalDateTime.now();
long nowInMillis = now.toEpochSecond(ZoneOffset.UTC) * 1000
                 + now.get(ChronoField.MILLI_OF_SECOND);
LocalDateTime dateTime = LocalDateTime.ofEpochSecond(nowInMillis / 1000,
                  (int) (nowInMillis % 1000 * 1000000), ZoneOffset.UTC);

System.out.println("now = " + now);
System.out.println("nowInMillis = " + nowInMillis);
System.out.println("dateTime = " + dateTime);

now = 2020-05-12T12:16:38.881510700
nowInMillis = 1589285798881
dateTime = 2020-05-12T12:16:38.881

如果需要，请指定utc以外的区域偏移量，但在这种情况下，您实际上应该使用zoneddatetime或offsetdatetime而不是localdatetime。