INT type

Applies to: Databricks SQL Databricks Runtime

Represents 4-byte signed integer numbers.

Syntax

{ INT | INTEGER }

Limits

The range of numbers is from -2,147,483,648 to 2,147,483,647.

Literals

[ + | - ] digit [ ... ]

digit: Any numeral from 0 to 9.

If the literal is outside of the range for an INT it will be implicitly turned into a BIGINT.

Examples

> SELECT +1;
  1

> SELECT CAST('5' AS INT);
  5

> SELECT typeof(-2147483649);
  BIGINT

Related

• TINYINT type
• SMALLINT type
• BIGINT type
• DECIMAL type
• FLOAT type
• DOUBLE type
• cast function