Subject Re: [firebird-support] Re: How do you fetch SmallInt data type using sqlda?
Author Helen Borrie
At 07:56 AM 18/04/2006, you wrote:

>On Apr 17, 2006, at 14:33, Helen Borrie wrote:
>
> > To be more exact, Fb 1.5 *overflows* with more than four decimals in
> > the fractional part of the seconds.
>
>FWIW, FB2 seems to still have this problem.

It's not a "problem". The time part of a timestamp is implemented as
a numeric(9,4) so, if you attempt to store a (9,5), you get an
overflow. Fb 2 still has a maximum subsecond precision of 10^ -4
but it has applied syntax so that you can set how precise you want it
to be (within that range).

./heLen