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.

smallint(expr)

• expr: Any expression which is castable to SMALLINT.

The result is SMALLINT.

> SELECT smallint(-5.6);
 5
> SELECT smallint('5');
 5

• cast function