Subject | Re: [firebird-support] Re: How do you fetch SmallInt data type using sqlda? |
---|---|
Author | Helen Borrie |
Post date | 2006-04-18T00:24:58Z |
At 07:56 AM 18/04/2006, you wrote:
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
>On Apr 17, 2006, at 14:33, Helen Borrie wrote:It's not a "problem". The time part of a timestamp is implemented as
>
> > 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.
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