I have an java.time.OffsetDateTime
which I would like to convert to a java.sql.Timestamp
. Since Timestamp
doesn't store any offset information, I am going to store all dates/times in the database as UTC.
How do I convert the OffsetDateTime
to a Timestamp
which is in UTC?
EDIT:
I believe this is the answer but it seems are rather convoluted way to covert to UTC:
OffsetDateTime dateTime = OffsetDateTime.now();
Timestamp timestamp = Timestamp.valueOf(dateTime.atZoneSameInstant(ZoneId.of("Z")).toLocalDateTime());
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…