On 03/18/18 23:16, Adriano dos Santos Fernandes wrote:
Is this constant correct?// Number of the first day of UNIX epoch in GDS counting enum { GDS_EPOCH_START = 40617 }; I see that for date 1970-01-01, Firebird stores it as 40587.
When counting days and month it's very easy to mix first day with zero day and first month with zero month. Why I type it - cause looks like that 30-day difference is to compensate such month in the only place where GDS_EPOCH_START is used currently - gds__trace(). What's funny is that something is anyway wrong with that code - from it's POV today is 18 of March, not 19 ;)
I suggest you to drop both that wrong code (no need in signal safety since 2.5, i.e. it can be replaced with TimeStamp functions) and suspicious constant. Add instead one you need.
------------------------------------------------------------------------------ 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
