Can I use… cast(… as int[eger])

1. Consider casting to unsigned or signed
2. Doesn’t fail on non-numeric input
3. Cast to int64 instead

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

SELECT CAST(column_name AS INTEGER)
  FROM …

Related

• Integer/int in other places: column type.

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

Normative References

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