Re: Pro*C: Loss of Decimal Places INSERTing From "double" Host Var into NUMBER(16,6) Column
From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Thu, 22 May 2008 09:00:02 -0700 (PDT)
Message-ID: <0e952ef0-dbbf-41e2-92bf-01717aa0cd58@j22g2000hsf.googlegroups.com>
> TVTime=(double)8589934592.123456; -> TVTime=8589934592.123455 <-- Loss
> starts now.
> TVTime=(double)8589934593.123456; -> TVTime=8589934593.123455
> TVTime=(double)8589934594.123456; -> TVTime=8589934594.123455
Date: Thu, 22 May 2008 09:00:02 -0700 (PDT)
Message-ID: <0e952ef0-dbbf-41e2-92bf-01717aa0cd58@j22g2000hsf.googlegroups.com>
On May 22, 10:35 am, "Fleetie" <flee..._at_nospam.com> wrote:
>> TVTime=(double)8589934591.123456; -> TVTime=8589934591.123456
> TVTime=(double)8589934590.123456; -> TVTime=8589934590.123456
> TVTime=(double)8589934592.123456; -> TVTime=8589934592.123455 <-- Loss
> starts now.
> TVTime=(double)8589934593.123456; -> TVTime=8589934593.123455
> TVTime=(double)8589934594.123456; -> TVTime=8589934594.123455
I don't see a loss, unless you made some copy/paste error: I see .123455 - that is 6 digits after the decimal point... Received on Thu May 22 2008 - 11:00:02 CDT