Subject Re: [firebird-support] Transaction isolation problem?
Author Mark Rotteveel
On 26-2-2010 9:01, Helen Borrie wrote:
> At 05:53 PM 26/02/2010, you wrote:
>> Nevermind. Found the problem using ISQL - apparently Firebird 2.1
>> changes TIMESTAMP precision from seconds to 0.0001 seconds, which is
>> causing difference between my OLD.MODIFIED_ON (4 decimal places
>> precision) and NEW.MODIFIED_ON (rounded down to seconds).
> You must be talking about the CURRENT_TIMESTAMP subsecond precision (not the TIMESTAMP data type).

PostgreSQL also allows specifying precision on the TIMESTAMP data type.
(see ).
It is also described in the SQL standard.

Mark Rotteveel