10.05.2018 19:02, Adriano dos Santos Fernandes wrote:
On 10/05/2018 12:53, Lester Caine wrote:
...
And how will the version of TZ data be handled! This is a key element
that has screwed normalized data in the past, and some way to manage
that normalized data needs to be included in the process.
If you mean "normalize data" as the fact that people uses an outdated
time zone db, insert data in the database on the outdated time zone, and
later update the db, the way to normalize data is up to the user/admin.
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.
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
