I am facing a round function related issues: SELECT ROUND(10.128) FROM DUAL OutputExpected: 10, OutputActual: 10.0
I also tried SELECT ROUND(10.128, 0) FROM DUAL, but that also gives same result. Even a multiplication which involves a double, but results into int value, gives a double output. select 100 * 0.1 from dual gives output as 10.0 instead of 10. Is this the expected behavior ? -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/bJmEEXRnrvoJ. 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.
