> 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.
IIRC, the Oracle time zone data (stored outside the engine) has 'effective date' context. Sean ------------------------------------------------------------------------------ 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