picoSQL - Language reference manual
picoSQL - Language reference manual |
|
In the following descriptions we denote a numeric expression as num-expr or num-expr-1, num-expr-2 etc.
|
ABS(num-expr) |
Returns the absolute value of the numeric expression.
|
|
ACOS(num-expr) |
Returns the arc-cosine of the numeric expression.
|
|
ASIN(num-expr) |
Returns the arc-sine of the numeric expression.
|
|
ATAN(num-expr) |
Returns the arc-tangent of the numeric expression.
|
|
CEILING(num-expr) |
Returns the smallest integer not less than the numeric expression.
|
|
COS(num-expr) |
Returns the cosine of the numeric expression.
|
|
COT(num-expr) |
Returns the cotangent of the numeric expression.
|
|
EXP(num-expr) |
Returns the exponential function of the numeric expression.
|
|
FLOOR(num-expr) |
Returns the largest integer not greater than the numeric expression.
|
|
LOG(num-expr) |
Returns the natural logarithm of the numeric expression.
|
|
LOG10(num-expr) |
Returns the logarithm base 10 of the numeric expression.
|
|
ROUND (num-expr-1, num-expr-2) |
Rounds num-expr-1 to num-expr-2 places after the decimal point.
|
|
SIGN(num-expr) |
Returns -1 if the numeric exprssion is less than 0, 1 if the numeric expression is greater than 0 or 0 if the numeric expression is equal to 0.
|
|
SIN(num-expr) |
Returns the sine of the numeric expression.
|
|
SQRT(num-expr) |
Returns the square roor of the numeric expression.
|
|
TAN(num-expr) |
Returns the tangent of the numeric expression.
|
|
TRUNCATE (num-expr-1, num-expr-2) |
Truncate num-expr-1 at num-expr-2 places after the decimal point.
|