cast(… as smallint)

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 SMALLINT)
  FROM …

Related

• Smallint in other places: column type.

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

Normative References

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