[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] Round Function Error in SQRW 3 and Oracle 7.3
- Subject: [sqr-users] Round Function Error in SQRW 3 and Oracle 7.3
- From: "Bryan Brown" <bryan_brown@vantageis.com>
- Date: Tue, 27 Jul 2004 11:28:16 -0800
- Delivery-date: Tue, 27 Jul 2004 14:29:26 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
- Thread-index: AcR0D9zyscrLXa3DTgqQzVQqkR25vg==
hi All,
I know that this is in the archives, but I can't seem to locate it. Can
anyone confirm a problem with the round function when using SQRW 3 and
Oracle 7.3? We have a case where a simple round statement returns two
different values.
round(#Aetna_Ded_Emp_Prem,2) In SQRW 3 / Oracle 7.3: 32.345 = 32.34.
round(#Aetna_Ded_Emp_Prem,2) In SQRW 6.2 / Oracle 9i: 32.345 = 32.35
Any insight?
Thanks,
Bryan
bryan_brown@vantageis.com
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users