Try Opteryx

INTEGER

Signed 64-bit integer. Write INTEGER, INT, or BIGINT in SQL — they are all equivalent.

Aliases: BIGINT, INT

Example

sql
SELECT 42;

Range

  • Min: -9223372036854775808
  • Max: 9223372036854775807

Casting

From Example Notes
from FLOAT 3.9::INTEGER Truncates toward zero — 3.9 becomes 3, -3.9 becomes -3
from BOOLEAN TRUE::INTEGER TRUE → 1, FALSE → 0
from VARCHAR '42'::INTEGER String must contain only digits with an optional leading minus sign — unlike FLOAT's VARCHAR cast, a leading '+' and surrounding whitespace are NOT tolerated
from TIMESTAMP ts_col::INTEGER Returns microseconds since the Unix epoch (1970-01-01 00:00:00 UTC)
from DATE date_col::INTEGER Returns days since the Unix epoch

Comparisons

Can be compared (using =, <, >, etc.) with: INTEGER, FLOAT, DECIMAL.

Limitations

  • Cannot compare INTEGER to VARCHAR or temporal types — cast first.
  • Arithmetic overflow fails loudly: +, -, *, unary minus and DIV whose exact result is outside the result type's range raise an error rather than wrapping (as SUM does). For unsigned integers that includes a subtraction that would go below zero.
  • Integer division (DIV) and modulo (%) by zero raise an error rather than returning 0. / is true division and follows IEEE, so x / 0 is ±inf or NaN.