TINYINT type

  • Article

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

Represents 1-byte signed integer numbers.

Syntax

{ TINYINT | BYTE }

Limits

The range of numbers is from -128 to 127.

Literals

[ + | - ] digit [ ... ] Y

digit: Any numeral from 0 to 9.

The Y postfix is case insensitive.

Examples

> SELECT +1Y;
  1

> SELECT CAST('5' AS TINYINT);
  5