24.03.2018 11:04, Mark Rotteveel wrote:
Why is the maximum precision of CURRENT_TIME(p) and CURRENT_TIMESTAMP(p) three (3) and not four (4)? The underlying data type has a precision up to 100 microseconds.
IIRC (but I may be wrong, it was lots of time ago): we cannot provide microsecond precision (only 4 digits are possible) and millisecond precision was easier to explain than 1/10 millisecond precision.
That said, I see no problems changing MAX_TIME_PRECISION to 4. Even better would be to support microseconds, but this would require a new underlying datatype. If I'm not mistaken, PostgreSQL uses 8-byte timestamp storage and provides microsecond precision, but I suppose their supported range of dates somewhat differs.
Dmitry ------------------------------------------------------------------------------ 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
