What is The ROUND function ?

  • 0 Replies
  • 378 Views
*

beingchinmay

  • Lifeasy
  • Newbie
  • *
  • 3
  • +0/-0
  • I am Chinmay
    • View Profile
    • On Demand Home Services
What is The ROUND function ?
« on: October 17, 2016, 08:28:50 AM »
The ROUND function returns the first argument rounded to the number of decimal places specified in the second argument. The specification for the ROUND function is:

Code: [Select]
FUNCTION ROUND (n NUMBER, [decimal_places NUMBER]) RETURN NUMBER;
The decimal_places argument is optional and defaults to 0, which means that n will be rounded to zero decimal places, a whole number. The value of decimal_places can be less than zero. A negative value for this argument directs ROUND to round digits to the left of the decimal point, rather than to the right. Here are some examples:

Code: [Select]
ROUND (153.46) ==> 153
ROUND (153.46, 1) ==> 153.5
ROUND (153, −1) ==> 150

 




See Our Webmaster Tools for Windows and Mac

A1 Sitemap Generator
      
A1 Website Analyzer
      
A1 Keyword Research
      
A1 Website Download
      
A1 Website Search Engine
      
A1 Website Scraper