ABS
Learn how to use the ABS numeric function in PlaidCloud Lakehouse. Returns the absolute value of x. Includes detailed syntax, examples, and usage reference.
Numeric Functions
This section provides reference information for the numeric functions in PlaidCloud Lakehouse.
ACOS
Learn how to use the ACOS numeric function in PlaidCloud Lakehouse. Returns the arc cosine of x, that is, the value whose cosine is x. With syntax and examples.
ADD
Learn how to use the ADD numeric function in PlaidCloud Lakehouse. Alias for PLUS. Adds two numeric values together. Includes syntax and examples.
ASIN
Learn how to use the ASIN numeric function in PlaidCloud Lakehouse. Returns the arc sine of x, that is, the value whose sine is x. Includes syntax and examples.
ATAN
Learn how to use the ATAN numeric function in PlaidCloud Lakehouse. Returns the arc tangent of x, that is, the value whose tangent is x. Includes syntax and...
ATAN2
Learn how to use the ATAN2 numeric function in PlaidCloud Lakehouse. Returns the arc tangent of the two variables x and y. Includes syntax and examples.
CBRT
Learn how to use the CBRT numeric function in PlaidCloud Lakehouse. Returns the cube root of a nonnegative number x. Includes syntax and examples.
CEIL
Learn how to use the CEIL numeric function in PlaidCloud Lakehouse. Rounds the number up. Includes detailed syntax, examples, and usage reference.
CEILING
Learn how to use CEILING in PlaidCloud Lakehouse. Alias for the CEIL numeric function. Includes detailed syntax, examples, and usage reference.
COS
Learn how to use the COS numeric function in PlaidCloud Lakehouse. Returns the cosine of x, where x is given in radians. Includes syntax and examples.
COT
Learn how to use the COT numeric function in PlaidCloud Lakehouse. Returns the cotangent of x, where x is given in radians. Includes syntax and examples.
CRC32
Learn how to use the CRC32 numeric function in PlaidCloud Lakehouse. Returns the CRC32 checksum of x, where 'x' is expected to be a string and (if possible)...
DEGREES
Learn how to use the DEGREES numeric function in PlaidCloud Lakehouse. Returns the argument x, converted from radians to degrees, where x is given in radians.
DIV
Learn how to use the DIV numeric function in PlaidCloud Lakehouse. Returns the quotient by dividing the first number by the second one, rounding down to the...
DIV0
Learn how to use the DIV0 numeric function in PlaidCloud Lakehouse. Returns the quotient by dividing the first number by the second one. Includes syntax and...
DIVNULL
Learn how to use the DIVNULL numeric function in PlaidCloud Lakehouse. Returns the quotient by dividing the first number by the second one. Includes syntax...
EXP
Learn how to use the EXP numeric function in PlaidCloud Lakehouse. Returns the value of e (the base of natural logarithms) raised to the power of x.
FACTORIAL
Learn how to use the FACTORIAL numeric function in PlaidCloud Lakehouse. Returns the factorial logarithm of x. Includes syntax and examples.
FLOOR
Learn how to use the FLOOR numeric function in PlaidCloud Lakehouse. Rounds the number down. Includes detailed syntax, examples, and usage reference.
INTDIV
Learn how to use INTDIV in PlaidCloud Lakehouse. Alias for the DIV numeric function. Includes detailed syntax, examples, and usage reference.
LN
Learn how to use the LN numeric function in PlaidCloud Lakehouse. Returns the natural logarithm of x; that is, the base-e logarithm of x. Includes syntax...
LOG(b, x)
Learn how to use the LOG(B, X) numeric function in PlaidCloud Lakehouse. Returns the base-b logarithm of x. Full syntax and usage reference.
LOG(x)
Learn how to use the LOG(X) numeric function in PlaidCloud Lakehouse. Returns the natural logarithm of x. Includes usage and syntax details.
LOG10
Learn how to use the LOG10 numeric function in PlaidCloud Lakehouse. Returns the base-10 logarithm of x. Reference with syntax and examples.
LOG2
Learn how to use the LOG2 numeric function in PlaidCloud Lakehouse. Returns the base-2 logarithm of x. Includes detailed syntax, examples, and usage reference.
MINUS
Learn how to use the MINUS numeric function in PlaidCloud Lakehouse. Negates a numeric value. Includes detailed syntax, examples, and usage reference.
MOD
Learn how to use MOD in PlaidCloud Lakehouse. Alias for the MODULO numeric function. Includes detailed syntax, examples, and usage reference.
MODULO
Learn how to use the MODULO numeric function in PlaidCloud Lakehouse. Returns the remainder of x divided by y. Includes syntax and examples.
NEG
Learn how to use NEG in PlaidCloud Lakehouse. Alias for the MINUS numeric function. Includes detailed syntax, examples, and usage reference.
NEGATE
Learn how to use NEGATE in PlaidCloud Lakehouse. Alias for the MINUS numeric function. Includes detailed syntax, examples, and usage reference.
PI
Learn how to use the PI numeric function in PlaidCloud Lakehouse. Returns the value of π as a floating-point value. Includes syntax and examples.
PLUS
Learn how to use the PLUS numeric function in PlaidCloud Lakehouse. Calculates the sum of two numeric or decimal values. Includes syntax and examples.
POW
Learn how to use the POW numeric function in PlaidCloud Lakehouse. Returns the value of x to the power of y. Full syntax and usage reference.
POWER
Learn how to use POWER in PlaidCloud Lakehouse. Alias for the POW numeric function. Includes detailed syntax, examples, and usage reference.
RADIANS
Learn how to use the RADIANS numeric function in PlaidCloud Lakehouse. Returns the argument x, converted from degrees to radians. Includes syntax and examples.
RAND()
Learn how to use the RAND() numeric function in PlaidCloud Lakehouse. Returns a random floating-point value v in the range 0 <= v < 1. With syntax and examples.
RAND(n)
Learn how to use the RAND(N) numeric function in PlaidCloud Lakehouse. Returns a random floating-point value v in the range 0 <= v < 1. Includes syntax and...
ROUND
Learn how to use the ROUND numeric function in PlaidCloud Lakehouse. Rounds the argument x to d decimal places. Includes syntax and examples.
SIGN
Learn how to use the SIGN numeric function in PlaidCloud Lakehouse. Returns the sign of the argument as -1, 0, or 1, depending on whether x is negative,...
SIN
Learn how to use the SIN numeric function in PlaidCloud Lakehouse. Returns the sine of x, where x is given in radians. Includes syntax and examples.
SQRT
Learn how to use the SQRT numeric function in PlaidCloud Lakehouse. Returns the square root of a nonnegative number x. Includes syntax and examples.
SUBTRACT
Learn how to use SUBTRACT in PlaidCloud Lakehouse. Alias for the MINUS numeric function. Includes detailed syntax, examples, and usage reference.
TAN
Learn how to use the TAN numeric function in PlaidCloud Lakehouse. Returns the tangent of x, where x is given in radians. Includes syntax and examples.
TRUNCATE
Learn how to use the TRUNCATE numeric function in PlaidCloud Lakehouse. Returns the number x, truncated to d decimal places. Includes syntax and examples.