On 12/12/2017 13:20, Alex Peshkoff via Firebird-devel wrote: > On 12/12/17 17:57, Adriano dos Santos Fernandes wrote: >> Oracle also mentions inconsistency that may happen when the time zone >> database is updated. If user had previously entered a time in a moment >> that subsequently has updated by the time zone db, it may become >> inconsistent. So it should be updated manually. > > May be also add a new type of trigger that will be invoked under such > circumstances? In some cases such time may be corrected automatically > according to business logic of data, stored in database. > I don't think a trigger for such event would be needed, but a context variable or virtual table with the time zone db version would be good, and it can be used in an ON CONNECT trigger.
Adriano ------------------------------------------------------------------------------ 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