Subject Re: [firebird-support] FB timestamp problems (a bit longer)
Author Helen Borrie

At 06:01 PM 14/01/2004 +0100, you wrote:

>We can't fill the timestamp values on the client and we don't know about
>any UDF (for Linux, FB CS) that correctly generates timestamps with full
>precision. And we really think that it's kind of unbelievable that FB1.5
>still can't generate timestamp with subsecond part :-((((

Unbelievable but true. As far as I understand it, it has to do with the
granularity (or lack thereof) of low-level timer calls on some POSIX
platforms with a consequent design decision to generalise on the lowest
common denominator to preserve cross-platformness. I consider it as a bug
until it a) becomes correctable and b) gets corrected.

>But perhaps someone has a solution for this.

In Firebird 1.5, you can use the UDF GetExactTimestamp(), in the library It doesn't take any argument but returns the exact timestamp
down to ten-thousandths of a second. The declaration is in fbudf.sql.

As for your timing and synchronicity appear to have some
systemic flaws regarding transaction isolation and data visibility.