smallint function

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime

Casts the value expr to SMALLINT.

Syntax 

smallint(expr)

Arguments

  • expr: Any expression which is castable to SMALLINT.

Returns

The result is SMALLINT.

This function is a synonym for CAST(expr AS SMALLINT).

See cast function for details.

Examples 

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