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 ?
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
