smallint
function
Applies to: Databricks SQL Databricks Runtime
Casts the value expr
to SMALLINT
. This function is a synonym for CAST(expr AS SMALLINT)
. See cast function for details.
Syntax
smallint(expr)
Arguments
expr
: Any expression which is castable toSMALLINT
.
Returns
The result is SMALLINT
.
Examples
> SELECT smallint(-5.6);
5
> SELECT smallint('5');
5