On 30/05/18 01:45, Adriano dos Santos Fernandes wrote:
RULE_START 2019-10-20 03:00:00.0000 GMT
RULE_END 2020-02-16 01:59:59.9999 GMT
ZONE_OFFSET -180
DST_OFFSET 60
-----------
It list all transition rules from the start to the end date, including
the pre-start and post-end in the same rule set of start and end
respectively.
I'm deliberately returning the timestamps in GMT time zone, but they can
be easily converted to the wanted one.
GMT is now somewhat archaic. The tzdist standard uses Zulu time for all
data, so 2008-01-01T00:00:00Z is the standard format.
Since you are producing an 'expanded' style format, there is no need to
have the RULE_END in every entry ... Just the 'onset' time as defined in
tzdist. The fractional times are somewhat strange since the rules are
all seconds based. Take care that some DST offsets are -ve but that is
because summer time is 'standard' in those locations ... not winter time.
And I still find the BODGE of dropping the second data from the offset
makes this only useable for current data. The first transition of EVERY
timezone has a second accurate variation so one has to revert to an
external set of rules for all dates prior to 1970 just to be safe! The
use of 'expanded' style only really works for short periods of time
anyway. You do not really want to handle the whole of the 20th century
showing every transition.
The question remains as to just what 'start date' the limited format
that is proposed here is designed to be used from.
--
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
