On 05/06/18 16:27, Adriano dos Santos Fernandes wrote:
Maybe it is just me, but it seems we are now having discussions that
should have been had and resolved before implementation.
In my whole life, I only see things being done when someone *really
does* it.
That discussion you were talking, before implementation, if nobody
implemented it, it would now be on one of two extremes: silent or that
b*t, does not work in another calendar, does not work outside earth,
does not work in my application if I do not change it...
But really test the implemented version, nobody does...
Or simply carry on using UTC timestamps exactly as they currently are
and manage timezone display using external tools which DO respect at
least some of the edge cases.
I do not recall seeing any discussion on the ground rules for handling
timezone offsets prior to an implementation being proposed? It could
then have been pointed out that the SQL rules simply don't work in a lot
of cases. The idea of listing the end time assumes that there will only
ever be 4 decimal places of second accuracy, but the involves cropping
current time systems. Avoiding the problem makes a lot more sense.
Guide lines created in RFC7808 address the majority of the problems
created by poorly thought out 'standards' like that included in the SQL
book. That RFC provides a clear set of rules to handle the very things
that are being reinvented currently ... and any timezone management
package should at least be capable of the same level of accuracy.
--
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
