On 05/10/18 19:40, 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 ?
Can it be instead hardcoded in the function(s), describing MSK timezone?
I ask cause building a system that describes well former whims of our
government appears useless - I believe they can invent something else in
the future which will be out of scope of system built to describe
previous solutions :-) But if we have no other way to describe MSK
timezone (i.e. with random changes of offset at given moments of time) -
in that case this will be required.
------------------------------------------------------------------------------
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