Red Hat Summit4.3.2.5. Numeric functions
The following functions support number operations.
- decimal( n, scale )
Returns a number with the specified scale.
Expand 表4.50 Parameters Parameter Type nnumberscalenumberin the range[−6111..6176]Examples
decimal( 1/3, 2 ) = .33 decimal( 1.5, 0 ) = 2 decimal( 2.5, 0 ) = 2- floor( n )
Returns the greatest integer that is less than or equal to the specified number.
Expand 表4.51 Parameters Parameter Type nnumberExamples
floor( 1.5 ) = 1 floor( -1.5 ) = -2- ceiling( n )
Returns the smallest integer that is greater than or equal to the specified number.
Expand 表4.52 Parameters Parameter Type nnumberExamples
ceiling( 1.5 ) = 2 ceiling( -1.5 ) = -1- abs( n )
Returns the absolute value.
Expand 表4.53 Parameters Parameter Type nnumber,days and time duration, oryears and months durationExamples
abs( 10 ) = 10 abs( -10 ) = 10 abs( @"PT5H" ) = @"PT5H" abs( @"-PT5H" ) = @"PT5H"- modulo( dividend, divisor )
Returns the remainder of the division of the dividend by the divisor. If either the dividend or divisor is negative, the result is of the same sign as the divisor.
注記This function is also expressed as
modulo(dividend, divisor) = dividend - divisor*floor(dividen d/divisor).Expand 表4.54 Parameters Parameter Type dividendnumberdivisornumberExamples
modulo( 12, 5 ) = 2 modulo( -12,5 )= 3 modulo( 12,-5 )= -3 modulo( -12,-5 )= -2 modulo( 10.1, 4.5 )= 1.1 modulo( -10.1, 4.5 )= 3.4 modulo( 10.1, -4.5 )= -3.4 modulo( -10.1, -4.5 )= -1.1- sqrt( number )
Returns the square root of the specified number.
Expand 表4.55 Parameters Parameter Type nnumberExample
sqrt( 16 ) = 4- log( number )
Returns the logarithm of the specified number.
Expand 表4.56 Parameters Parameter Type nnumberExample
decimal( log( 10 ), 2 ) = 2.30- exp( number )
Returns Euler’s number
eraised to the power of the specified number.Expand 表4.57 Parameters Parameter Type nnumberExample
decimal( exp( 5 ), 2 ) = 148.41- odd( number )
Returns
trueif the specified number is odd.Expand 表4.58 Parameters Parameter Type nnumberExamples
odd( 5 ) = true odd( 2 ) = false- even( number )
Returns
trueif the specified number is even.Expand 表4.59 Parameters Parameter Type nnumberExamples
even( 5 ) = false even ( 2 ) = true
'%20d='M201.5%20305.5c-13.8%200-24.9-11.1-24.9-24.6%200-13.8%2011.1-24.9%2024.9-24.9%2013.6%200%2024.6%2011.1%2024.6%2024.9%200%2013.6-11.1%2024.6-24.6%2024.6zM504%20256c0%20137-111%20248-248%20248S8%20393%208%20256%20119%208%20256%208s248%20111%20248%20248zm-132.3-41.2c-9.4%200-17.7%203.9-23.8%2010-22.4-15.5-52.6-25.5-86.1-26.6l17.4-78.3%2055.4%2012.5c0%2013.6%2011.1%2024.6%2024.6%2024.6%2013.8%200%2024.9-11.3%2024.9-24.9s-11.1-24.9-24.9-24.9c-9.7%200-18%205.8-22.1%2013.8l-61.2-13.6c-3-.8-6.1%201.4-6.9%204.4l-19.1%2086.4c-33.2%201.4-63.1%2011.3-85.5%2026.8-6.1-6.4-14.7-10.2-24.1-10.2-34.9%200-46.3%2046.9-14.4%2062.8-1.1%205-1.7%2010.2-1.7%2015.5%200%2052.6%2059.2%2095.2%20132%2095.2%2073.1%200%20132.3-42.6%20132.3-95.2%200-5.3-.6-10.8-1.9-15.8%2031.3-16%2019.8-62.5-14.9-62.5zM302.8%20331c-18.2%2018.2-76.1%2017.9-93.6%200-2.2-2.2-6.1-2.2-8.3%200-2.5%202.5-2.5%206.4%200%208.6%2022.8%2022.8%2087.3%2022.8%20110.2%200%202.5-2.2%202.5-6.1%200-8.6-2.2-2.2-6.1-2.2-8.3%200zm7.7-75c-13.6%200-24.6%2011.1-24.6%2024.9%200%2013.6%2011.1%2024.6%2024.6%2024.6%2013.8%200%2024.9-11.1%2024.9-24.6%200-13.8-11-24.9-24.9-24.9z'/%3e%3c/svg%3e){kind=small}