The numeric function is one of the commonly used functions, but also to learn MySQL must, commonly used are as follows: 1, Ceil: Returns the smallest integer value greater than a number: 2, Floor: And on the contrary, returns the maximum integer value less than a number: 3, round: Returns the value after a value is rounded: for example, The second parameter of the round represents the number of decimal digits that need to be preserved. 4. Truncate: Returns the value after a value has been truncated: unlike round, the second parameter represents the number of decimal digits that need to be retained, regardless of the number of decimal digits that need to be left behind. Note: The above examples are integers, but these functions can also handle negative numbers the same way. The numeric functions are more than these, but these few I personally think are more commonly used, so just record these few. The numeric function is one of the commonly used functions, but also to learn MySQL must, commonly used are as follows: 1, Ceil: Returns the smallest integer value greater than a number: 2, Floor: And on the contrary, returns the maximum integer value less than a number: 3, round: Returns the value after a value is rounded:
1. About PHP ceil () functions 10 articles recommended
Introduction: Numerical function is one of the commonly used functions, but also to learn MySQL must be, commonly used are as follows: 1, Ceil: Returns the smallest integer value greater than a number: 2, Floor: And the previous opposite, returns the maximum integer value less than a certain number: 3, Round: Returns the value after a value is rounded: for example, the second parameter of round represents the number of decimal digits that need to be preserved. 4. Truncate: Returns the value after a value has been truncated: unlike round here, no matter what number of decimal digits you need to keep ...
2. Detailed analysis of Python3 and floor division usage in detail
Introduction: This article mainly introduces the Python3 and floor division usage, combined with examples to analyze the difference between real and floor division and the use of skills, the need for friends can refer to the following
3. mysql Common basic operation Syntax (12) ~ ~ Common numeric Functions "command line Mode"
Introduction: Numerical function is one of the commonly used functions, but also to learn MySQL must be, commonly used are as follows: 1, Ceil: Returns the smallest integer value greater than a number: 2, Floor: And the previous opposite, returns the maximum integer value less than a number: 3, round: Returns the value after a value is rounded: For example, the second parameter of round represents the number of decimal digits that need to be preserved. 4. Truncate: Returns the value after a value has been truncated: unlike round here, no matter what number of decimal digits you need to keep,
4. mysql numeric operators and functions
Summary: For general addition and subtraction operations, this is not explained in detail, as the following example:mysql> SELECT 3+4;+-----+| 3+4 |+-----+| 7 |+-----+1 row in Set (0.03 sec) Ceil and Floorceil for rounding up, as long as there are decimal digits, no matter how many, directly into one. For example:mysql> SELECT ceil (3.01);
5. js operation rounding and string segmentation
Summary: "Rounding" ①parseint (parsing integer, discarding fractional part, preserving integer part) syntax: var a =parseint (5/2); Console.log (a) output 2②math.ceil (rounded up, with fractional integers plus 1) syntax: Math.ceil (5/2) output 3③math.round (rounding) Syntax: Math.Round (5/2) Output 3 ④math.floor (rounding down) Math.floo ...
6. js operation rounding and string segmentation
Summary: "Rounding" ①parseint (parsing integer, discarding fractional part, preserving integer part) syntax: var a =parseint (5/2); Console.log (a) output 2②math.ceil (rounded up, with fractional integers plus 1) syntax: Math.ceil (5/2) output 3③math.round (rounding) Syntax: Math.Round (5/2) Output 3 ④math.floor (rounding down) Math.floo ...
7. Python up rounding ceil down to rounding round
Summary: Python ceil up the entire floor rounding down round
8. About sprintf interception of decimals
Introduction: Question: Retain 1 decimal places, not rounded, for integer when 0 many people say with sprintf ('%.1f ', $str), but the results are still problematic, and finally solved with this method: Echo sprintf ('%.1f ', Floor ($STR)); {Code ...} Not to say no rounding? Why ...?
9. About sprintf interception of decimals
Introduction: Question: Retain 1 decimal places, not rounded, for integer when 0 many people say with sprintf ('%.1f ', $str), but the results are still problematic, and finally solved with this method: Echo sprintf ('%.1f ', Floor ($STR)); {Code ...} Not to say no rounding? Why ...?
PHP's floor function problem.
Introduction:: This article mainly introduces the floor function problem of PHP. , for the PHP tutorial interested students can refer to.
"Related question and answer recommendation":
Javascript-js in "20/3 | 1 "What does that mean?
PHP-Regular Expressions
MySQL-ask for a PHP logic code
Javascript-angular First click Anchor to refresh the controller the second time click on the anchor point to jump to the corresponding location
PHP-Find a MySQL logic