Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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