Getting started
User guides
Administration guides
Reference guides
Resources
Updated Aug 04, 2022
Send us feedback
TINYINT
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