10.05.2018 19:57, Adriano dos Santos Fernandes пишет:
On 10/05/2018 13:47, Vlad Khorsun via Firebird-devel wrote:
10.05.2018 19:23, Adriano dos Santos Fernandes wrote:
On 10/05/2018 13:12, Vlad Khorsun via Firebird-devel wrote:
I guess the question is about the case when users have historical
data
and need to apply old time zone rule to the old data and new timezone
rule
to the new data.
Is it possible\make sence to add a datetime field with "valid from"
mark ? Or something like that, some kind of version mark.
I really don't understood what you mean.
Please give more practical example.
Look how MSK time zone was changed at 2014.10.26
https://www.timeanddate.com/time/zone/russia/moscow
I think about something like this:
ID Name Valid from Offset
... MSK 2011.03.27 02:00 +4
... MSK 2014.10.26 02:00 +3
Is it makes sence ?
America/Sao_Paulo changes every year because DST (when starting to -02
and ending to -03).
The case is not about DST. It is about *change of rule* for particular
time zone. Does you read table at link above ?
If i understand it correct:
2010.03.01 04:00 MSK == 2010.03.01 00:00 UTC,
2013.03.01 04:00 MSK == 2013.03.01 00:00 UTC, but
2016.03.01 04:00 MSK == 2016.03.01 01:00 UTC
Regards,
Vlad
------------------------------------------------------------------------------
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
