Is there simple way of changing timezone between dto and entities at database?-CodePudding

I write application on Spring Boot with Spring Data(postgresql).

I have the following case. I want to store in database time at UTC timezone, and parse it to/from "America/San-Paulo" timezone in dto.

For example: in controller I get dto with LocalDateTime in America/San-Paulo timezone. And I want to save it in database in UTC timezone.

I can do in when mapping from dto to entity. But maybe there is another simple way like setting some properties of hibernate/spring?

CodePudding user response：

Since Java 8, we have the Date/Time API under java.time!

(1) Convert the timezone in annotated @PrePersist, @PreUpdate, and @PostLoad methods.

For example, in annotated @PostLoad, convert from UTC to America/San-Paulo.

private static ZoneId UTC_ZONE = ZoneId.of("UTC");
private static ZoneId LOCAL_ZONE = ZoneId.of("America/San_Paulo");

private LocalDateTime dateTime;

@PostLoad
public void toLocal() {
  dateTime = dateTime.atZone(UTC_ZONE).withZoneSameInstant(LOCAL_ZONE).toLocalDateTime();
}

(2) Assuming you are using Jackson, you can write a custom serializer/deserializer.