> I'm not against tools to help one fix timestamps after rule change, but > definitively that should be tools, not the storage of values that should > be changed.
What I'm trying to say, that simply storing in UTC+TZ is not enough, because at the minimum you need at least (1) the TZ data version so you can do the conversion yourself - either fixing "local" time or UTC time. But you can't get that information now. (1) The real location of that timestamp would be even better, because sometimes locations/cities even change what TZ they belong to. But that's another level of mess with timezones. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel