Spring JPA使用criteria builder将带有时区的时间戳转换为带有给定时区的本地时间

import javax.persistence.EntityManager;
import javax.persistence.criteria.CriteriaBuilder;
import javax.persistence.criteria.CriteriaQuery;
import javax.persistence.criteria.Root;
import java.time.LocalDateTime;
import java.time.ZoneId;

public class TimestampConverter {
    private EntityManager entityManager;

    public LocalDateTime convertTimestampWithTimezone(LocalDateTime timestamp, ZoneId targetZone) {
        CriteriaBuilder cb = entityManager.getCriteriaBuilder();
        CriteriaQuery<LocalDateTime> query = cb.createQuery(LocalDateTime.class);
        Root<?> root = query.from(Object.class); // 替换为实际的实体类

        query.select(cb.function("convert_timezone", LocalDateTime.class,
                root.get("timestamp"), cb.literal(targetZone.getId())));

        return entityManager.createQuery(query).getSingleResult();
    }
}