Re: 0E-27 is a correct, but a bit a stupid representation of the value zero

Thu, 15 Mar 2012 02:37:32 -0700 

That's just how BigDecimal prints it's numbers.

On 2012-03-15 10:17, cool2man wrote:

CREATE SCHEMA IF NOT EXISTS TEST AUTHORIZATION SA;

CREATE CACHED TABLE IF NOT EXISTS TEST.TEST(
     PRM NUMERIC(8, 2),
     SBT NUMERIC(8, 2)
);

INSERT INTO TEST.TEST(PRM, SBT) VALUES (17852.08, 0.00);

SELECT PRM, SBT, CASE WHEN PRM>  0 THEN 100 / PRM * SBT ELSE 0 END
FROM TEST.TEST;


--
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en.

Reply via email to