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 to SMALLINT.

Returns

The result is SMALLINT.

If expr is a STRING that cannot be parsed as a number, Azure Databricks raises a CAST_INVALID_INPUT error. If the value overflows the SMALLINT range, Azure Databricks raises a CAST_OVERFLOW error.

Common error conditions

• CAST_INVALID_INPUT
• CAST_OVERFLOW

Examples

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

> SELECT smallint('abc');
  Error: CAST_INVALID_INPUT

Related functions

• cast function