On 12/12/2017 13:42, Lester Caine wrote: > and it's the version data that is missing in the Oracle 'solution' ... It's not that simple. Date/times are considered equal if their conversion to UTC are equal, independent of region.
So, they are converted to UTC for storage. To convert to UTC, one needs correct tzdata. If tzdata is changed after conversion, conversion became wrong, as the date/time will still be in UTC, but when converted back it will result in wrong date/time. So one cannot fix the back-conversion. It's initially stored incorrectly. Adriano ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel