Hi, ROUND isn't about formatting, it's really only about the mathematical rounding part.
Regards, Thomas On Fri, Jun 29, 2012 at 8:40 PM, Vinod <[email protected]> wrote: > I am facing a round function related issues while rounding to 0 decimal > places: > > 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. > > Also 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 desired 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/-/jN85uY5KgWgJ. > 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. -- 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.
