On 01/05/2018 11:19, Adriano dos Santos Fernandes wrote: > > Let's say first about TIMESTAMP. >
Why this? Because TIME if more problematic. :) The standard (at least up to the 2013 drafts) does not talk about TZ regions, but only offsets. And a TIME with TZ region is problematic. Because there is no very logical thing as just 10:00 of America/Sao_Paulo. We need to known what TIME '10:00 America/Sao_Paulo' is in UTC, and for that we need a date. So every time we need a date, we get the current date. So times with region timezones changes (their conversion from stored UTC to something else) when DST start or end. TIMESTAMP changes only if the timezone db is updated and a date/time was used with an updated range. 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
