我有一个有电影时间表的数据库。好吧,当然有两个这样的列:
CREATE TABLE tableName (
hall_movies_schedules_id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
hall_id BIGINT UNSIGNED NOT NULL,
film_id BIGINT UNSIGNED NOT NULL,
start_at TIME NOT NULL,
end_at TIME NOT NULL,
date DATE NOT NULL,
cost INT UNSIGNED NOT NULL,
FOREIGN KEY(hall_id) REFERENCES cinema_halls(hall_id),
FOREIGN KEY(film_id) REFERENCES films(film_id),
PRIMARY KEY (hall_movies_schedules_id)
);
我在Java代码中有实体:
@Entity
@Table(name="tableName")
public class HallMoviesSchedule {
...
@Column(nullable = false, name = "start_at")
@DateTimeFormat(iso = DateTimeFormat.ISO.TIME)
private LocalTime startAt;
@Column(nullable = false, name = "end_at")
@DateTimeFormat(iso = DateTimeFormat.ISO.TIME)
private LocalTime endAt;
...
}
但是将信息拖到我的网页上比我所在区域的数据库少一小时。如何解决?
最佳答案
LocalTime
没有TimeZone
。您必须改为使用ZonedDateTime
。