floor
function
Applies to: Databricks SQL Databricks Runtime 10.4 LTS and above
Returns the largest number not bigger than expr
rounded down to targetScale
digits relative to the decimal point.
Arguments
expr
: An expression that evaluates to a numeric.targetScale
: An optional INTEGER literal greater than-38
specifying by how many digits after the decimal points to round down.
Returns
If no targetScale
is given:
If
expr
isDECIMAL(p, s)
, returnsDECIMAL(p - s + 1, 0)
.For all other cases, returns a BIGINT.
If targetScale
is specified and expr
is a:
TINYINT
Returns a
DECIMAL(p, 0)
withp = max(3, -targetScale + 1)
.SMALLINT
Returns a
DECIMAL(p, 0)
withp = max(5, -targetScale + 1)
.INTEGER
Returns a
DECIMAL(p, 0)
withp = max(10, -targetScale + 1))
.BIGINT
Returns a
DECIMAL(p, 0)
withp = max(20, -targetScale + 1))
.FLOAT
Returns a
DECIMAL(p, s)
withp = max(14, -targetScale + 1))
ands = min(7, max(0, targetScale))
DOUBLE
Returns a
DECIMAL(p, s)
withp = max(30, -targetScale + 1))
ands = min(15, max(0, targetScale))
DECIMAL(p_in, s_in)
Returns a
DECIMAL(p, s)
withp = max(p_in - s_in + 1, -targetScale + 1))
ands = min(s_in, max(0, targetScale))
If targetScale
is negative the rounding occurs to -targetScale
digits to the left of the decimal point.
The default targetScale
is 0, which rounds down to the next smaller integral number.