Rounding to 2 decimal places in SQL

Question

every time I want to round to 2 decimal places when it comes to zeros it doesnt want to round it    how could I round it to 2 decimal places with zeros at the end which would give me 92 00 instead of just 92      SELECT ROUND COLUMN NAME 2  FROM        it s giving me   COLUMN NAME 92   but I want   COLUMN NAME 92 00   I used TO CHAR and it worked  ROUND TO CHAR COLUMN NAME  2    thanks guys

User · Answer

Try using the COLUMN command with the FORMAT option for that   COLUMN COLUMN NAME FORMAT 99 99 SELECT COLUMN NAME FROM

User · Answer

Try to avoid formatting in your query  You should return your data in a raw format and let the receiving application  e g  a reporting service or end user app  do the formatting  i e  rounding and so on    Formatting the data in the server makes it harder  or even impossible  for you to further process your data  You usually want export the table or do some aggregation as well  like sum  average etc  As the numbers arrive as strings  varchar   there is usually no easy way to further process them  Some report designers will even refuse to offer the option to aggregate these  numbers    Also  the end user will see the country specific formatting of the server instead of his own PC   Also  consider rounding problems  If you round the values in the server and then still do some calculations  supposing the client is able to revert the number-strings back to a number   you will end up getting wrong results

User · Answer

Try this    SELECT TO CHAR column name  99G999D99MI   as format column FROM DUAL

User · Answer

you may try the TO CHAR function to convert the result  e g   SELECT TO CHAR 92   99 99   AS RES FROM DUAL  SELECT TO CHAR 92 258   99 99   AS RES FROM DUAL   Hope it helps

User · Answer

This works too  The below statement rounds to two decimal places   SELECT ROUND 92 258 2  from dual

[sql] Rounding to 2 decimal places in SQL

Examples related to sql

Examples related to oracle

Examples related to rounding