ABS( number ) |
||
ACOS( cosine ) |
||
ASIN( sin ) |
||
ATAN( tangent ) |
||
ATAN2( x, y ) |
||
CEILING( number ) CEIL( number ) |
||
COS( radians ) |
||
COT( radians ) |
||
DEGREES( radians ) |
||
EXP( number ) |
Returns the constant e raised to the specified power.
|
|
FLOOR( number ) |
||
LN( number ) LOG( number ) |
||
LOG10( number ) |
||
MAX( n1, n2, ... ) |
||
MIN( n1, n2, ... ) |
||
MOD( dividend, divisor ) |
Returns the remainder when dividend is divided by divisor. Floating-point values are truncated to integers before the modulus operation is performed.
|
|
PI() |
||
POWER( number, power ) POW( number, power ) |
||
RADIANS( degrees ) |
||
RANDOM() RANDOM( max ) RANDOM( min, max ) |
Returns a random number. RANDOM() returns a number between 0 and 1. RANDOM( max ) returns a number between 0 and max. RANDOM( min, max ) returns a number between min and max. This function is equivalent to the Random Uniform() JSL function, and its seed can be controlled using the Random Reset() JSL function. RANDOM can be shortened to RAND.
|
|
RANDOMBLOB( length ) |
Returns an N-byte blob that contains pseudo-random bytes. See the SQLite Online documentation at https://www.sqlite.org/lang.html for details.
|
|
ROUND( number, <precision> ) |
Rounds number to the number of decimal places given by precision. The default value of precision is 0, and precision can be negative.
|
|
SIGN( number ) |
||
SIN( radians ) |
||
SQRT( number ) |
Returns the square root of number.
|
|
TAN( radians ) |
||
TRUNCATE( number, <precision> ) |
Truncates number at the number of decimal places given by precision. The default value of precision is 0, and precision can be negative. TRUNCATE() can be shortened to TRUNC().
|