cast(… as bigint)

1. Consider casting to unsigned or signed
2. Cast to integer instead (supports 38 decimal digits on this platform)
3. Doesn’t fail on non-numeric input
4. Cast to int64 instead

The SQL cast specification converts a value to the named data type.

SELECT CAST(column_name AS BIGINT)
  FROM …

Related

• Bigint in other places: column type.

• Product specific cast functions: try_cast, safe_cast, ::, convert.

Normative References

ISO/IEC 9075-2:2023 defines integer (E011-01, “INTEGER and SMALLINT data types (including all spellings)”) and the cast specification (F201).