On 06/06/18 15:12, Adriano dos Santos Fernandes wrote:
I understand that is a bit weird to have the end data defined to the .9999 seconds, but it's the max. Firebird precision. If precision increases, it would be increased too, of course.
That is part of the point. It is only valid within Firebird. Ideally we need 'next' outside of Firebird. There are some places where 'between' works and others where 'gt/lt' IS the correct process in order to remove problems cause by differing precision settings.
-- Lester Caine - G8HFL ----------------------------- Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk Rainbow Digital Media - http://rainbowdigitalmedia.co.uk ------------------------------------------------------------------------------ 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