Hi, Maybe what you are looking for is CAST:
CAST(10.6 AS BIGINT) or CAST(ROUND(10.6, 0) AS BIGINT) Regards, Thomas On Thu, Jul 5, 2012 at 7:44 AM, Thomas Mueller <[email protected]> wrote: > 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.
