ZonedDateTimeBridge stores time in an ambiguous representation

Description

The bridge stores time as a timestamp + the zone ID. Unfortunately, this representation is ambiguous for some timestamps, in particular when clocks are set back due to switching daylight saving time. For instance "2011-10-30 2:50:00 CET" may point to either "2011-10-30 2:50:00+01:00" or "2011-10-30 2:50:00+02:00".
A safer string representation would be something like what's done in java.time.format.DateTimeFormatter.ISO_ZONED_DATE_TIME, where both the offset and the zone ID are explicitly stored (something like "2011-10-30 2:50:00+01:00[CET]")

Some strategy will have to be chosen to handle previously stored ZonedDateTimes, since we'll have to change the storing format and cannot assume that users will reindex everything.

Attached is a patch adding a test case (but no fix yet).

Environment

None

Attachments

Assignee

Yoann Rodière

Reporter

Yoann Rodière

Labels

None

Suitable for new contributors

None

Feedback Requested

None

Components

Fix versions

Affects versions

Priority

Major
Configure