Get started
Load & manage data
Work with data
Administration
Reference & resources
ARRAY
BIGINT
BINARY
BOOLEAN
DATE
DECIMAL
DOUBLE
FLOAT
INT
INTERVAL
MAP
VOID
OBJECT
SMALLINT
STRING
STRUCT
TIMESTAMP_NTZ
TIMESTAMP
TINYINT
VARIANT
CLUSTER BY
mask
ROW FILTER
更新しました 2025/02/07
Send us feedback
Applies to: Databricks SQL Databricks Runtime
Represents 1-byte signed integer numbers.
{ TINYINT | BYTE }
The range of numbers is from -128 to 127.
[ + | - ] digit [ ... ] Y
digit: Any numeral from 0 to 9.
digit
The Y postfix is case insensitive.
Y
> SELECT +1Y; 1 > SELECT CAST('5' AS TINYINT); 5
SMALLINT type
INT type
BIGINT type
DECIMAL type
FLOAT type
DOUBLE type
cast function