I checked out a few databases and the behavior while rounding using 0 was to remove the decimal part: Oracle: http://www.techonthenet.com/oracle/functions/round_nbr.php PostgreSql: http://www.postgresql.org/docs/8.1/static/functions-math.html Derby: does not have round function.
Even http://www.w3schools.com/sql/sql_func_round.asp shows rounding using 0 as removing the decimal part. Are there some databases out there where rounding using 0 expect a decimal part of '.0' ? On Thursday, July 5, 2012 1:49:35 AM UTC-4, Thomas Mueller wrote: > > 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 view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/7pU2_4iXrx4J. 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.
