Re: Pro*C: Loss of Decimal Places INSERTing From "double" Host Var into NUMBER(16,6) Column
From: <fitzjarrell_at_cox.net>
Date: Wed, 21 May 2008 10:34:15 -0700 (PDT)
Message-ID: <c1edb507-09f5-4f01-bc5d-97f7338b254b@l64g2000hse.googlegroups.com>
Date: Wed, 21 May 2008 10:34:15 -0700 (PDT)
Message-ID: <c1edb507-09f5-4f01-bc5d-97f7338b254b@l64g2000hse.googlegroups.com>
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,
>
> Martin
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