Subject | .NET Provider and exponential numbers |
---|---|
Author | donjules2k |
Post date | 2004-10-07T23:01:45Z |
Hi,
If i do arrithmetic on two dates e.g. (25/09/2004
10:08:03)-(25/09/2004 10:08:02) then the answer is 1 second. Which
when expressed in Days becomes: 1.1574E-5. This is what firebird
correctly returns. However, the .Net provider is returning to me
91.804930555 which is wrong. I'm guessing is a problem in the double
conversion or is being cast to the wrong data type. Any ideas Carlos?
Thanks
Giulio
If i do arrithmetic on two dates e.g. (25/09/2004
10:08:03)-(25/09/2004 10:08:02) then the answer is 1 second. Which
when expressed in Days becomes: 1.1574E-5. This is what firebird
correctly returns. However, the .Net provider is returning to me
91.804930555 which is wrong. I'm guessing is a problem in the double
conversion or is being cast to the wrong data type. Any ideas Carlos?
Thanks
Giulio