On 06/06/18 09:07, Jiří Činčura wrote:
That is still no argument to leave the end of the range out of the
provided information. Including it will have little to no cost, and
provides full information in one record, which makes it self-contained
and easy to understand.
Could it be that the data will be stored without "end" column and for
convenience a view would be provided? I totally get Lester's point. The end column kind
of breaks normalization.
There is little reason for creating a database of every transition for
every timezone and storing them. One simply processes the rule set and
creates what is needed on the fly. And for the majority of non-dst
timezones the rule is the transition ...
--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk
------------------------------------------------------------------------------
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
