This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
dev:sql:functions:round [2010/07/09 04:38] els |
dev:sql:functions:round [2016/10/15 04:48] (current) doc |
||
|---|---|---|---|
| Line 7: | Line 7: | ||
| ===== Syntax ===== | ===== Syntax ===== | ||
| - | $ROUND(numeric_expression [, n]) | + | ROUND(numeric_expression [, n]) |
| == numeric_expression == | == numeric_expression == | ||
| Line 35: | Line 35: | ||
| </code> | </code> | ||
| - | === Example 2: Column rounded to a set number of decimal places === | + | ==== Example 2: Column rounded to a set number of decimal places ==== |
| Note that floating point values cannot represent ever value, and the values shown below are as close as floating point values can represent. | Note that floating point values cannot represent ever value, and the values shown below are as close as floating point values can represent. | ||
| Line 52: | Line 52: | ||
| 40.000000 40.000000 | 40.000000 40.000000 | ||
| </code> | </code> | ||
| + | |||
| + | ====== Additional Resources ====== | ||
| + | |||
| + | See also: | ||
| + | {{page>dev:sql:functions:see_also_math&noheader&nofooter&noeditbtn}} | ||
| + | |||
| {{page>:bottom_add&nofooter&noeditbtn}} | {{page>:bottom_add&nofooter&noeditbtn}} | ||