banner
RustyNail

RustyNail

coder. 【blog】https://rustynail.me 【nostr】wss://ts.relays.world/ wss://relays.world/nostr
HomeArchives

Stolen Time in the Field

57
AI Translation
This post is translated from Chinese into English through AI.View Original
AI-generated summary
When storing an entity, a time is stored. If the time is read back and is 8 hours behind, it is likely in Greenwich Mean Time (GMT). There are two solutions: either read the time with GMT+8 or store the time with GMT+8. The first solution involves specifying the database's time zone as GMT+8. The second solution involves adding the annotation @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") to the entity class's field.

When storing an entity, if a time is stored and then read out, if it is 8 hours behind, it is probably Greenwich Mean Time (GMT).

Solution:
There are two options:

  • When reading, read it as GMT+8.
  • When storing, store it as GMT+8.

The first option is to specify the time zone of the database.

[mysqld]
default-time-zone = '+8:00'

The second option is to add @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") to the field in the entity class.

Loading...
Ownership of this post data is guaranteed by blockchain and smart contracts to the creator alone.