Pular para o conteúdo principal

tinyint function

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

Casts expr to TINYINT. This function is a synonym for CAST(expr AS TINYINT). See cast function for details.

Syntax

tinyint(expr)

Arguments

  • expr: Any expression which is castable to TINYINT.

Returns

The result is TINYINT.

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

Common error conditions

Examples

SQL
> SELECT tinyint('12');
12
> SELECT tinyint(5.4);
5

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