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
Atualizado 11/02/2025
Send us feedback
Applies to: Databricks SQL Databricks Runtime
Represents 2-byte signed integer numbers.
{ SMALLINT | SHORT }
The range of numbers is from -32,768 to 32,767.
[ + | - ] digit [ ... ] S
digit: Any numeral from 0 to 9.
digit
The postfix S is case insensitive.
S
> SELECT +1S; 1 > SELECT CAST('5' AS SMALLINT); 5
TINYINT type
INT type
BIGINT type
DECIMAL type
FLOAT type
DOUBLE type
cast function