TINYINT
type
Applies to: Databricks SQL Databricks Runtime
Represents 1-byte signed integer numbers.
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