Re: [Firebird-devel] Max precision of CURRENT_TIME(p) and CURRENT_TIMESTAMP(p)

2018-03-24 Thread Slavomir Skopalik
Hi, about PostgeSQL you can look here: https://www.postgresql.org/docs/9.1/static/datatype-datetime.html Some details about time in firebird: Now using 30 bits from 32 available bits for time. Max value is 864 000 000-1, I'm not sure how firebird play with leap second. Postgre using in time s

Re: [Firebird-devel] Max precision of CURRENT_TIME(p) and CURRENT_TIMESTAMP(p)

2018-03-24 Thread Dmitry Yemanov
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 prec

[Firebird-devel] Max precision of CURRENT_TIME(p) and CURRENT_TIMESTAMP(p)

2018-03-24 Thread Mark Rotteveel
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. -- Mark Rotteveel -- Check out the vibrant tech commu