SMALLINT
type
Applies to: Databricks SQL
Databricks Runtime
Represents 2-byte signed integer numbers.
Syntax
{ SMALLINT | SHORT }
Limits
The range of numbers is from -32,768 to 32,767.
Literals
[ + | - ] digit [ ... ] S
digit
: Any numeral from 0 to 9.
The postfix S
is case insensitive.
Examples
> SELECT +1S;
1
> SELECT CAST('5' AS SMALLINT);
5
Related
Feedback
https://aka.ms/ContentUserFeedback.
Kommer snart: I hele 2024 udfaser vi GitHub-problemer som feedbackmekanisme for indhold og erstatter det med et nyt feedbacksystem. Du kan få flere oplysninger under:Indsend og få vist feedback om