Re: Pro*C: Loss of Decimal Places INSERTing From "double" Host Var into NUMBER(16,6) Column
Date: Wed, 21 May 2008 10:34:15 -0700 (PDT)
On May 21, 9:41 am, "Fleetie" <flee..._at_nospam.com> wrote:
> > Use timestamp datatype.
> > Jim
> Forgetting for now what the data is representing - pretend it's just a
> number with 6 decimal places right of the point - I would still like to
> know why my data is getting truncated.
> I did not design this database I'm working on; it's >10 years old, and
> I can't change it.
> So anyone know why the truncation?
> Thanks in advance,
Not without seeing the source code for the Pro*C program. You do realize that there is the BINARY_DOUBLE datatype available?
David Fitzjarrell Received on Wed May 21 2008 - 12:34:15 CDT