int64
insteadunsigned
or signed
The SQL cast
specification converts a value to the named data type.
SELECT CAST(column_name AS INTEGER
)
FROM …
Integer
/int
in other places: column type.
Product specific cast functions: try_cast
, safe_cast
, ::
, convert
.
ISO/IEC 9075:2016-2 defines integer
(E011-01, “INTEGER
and SMALLINT
data types (including all spellings)”) and the cast
specification (F201).
The essence of SQL tuning in 200 pages
Buy on Amazon
(paperback only)
Paperback and PDF also available at Markus’ store.
Markus offers SQL training and consulting for developers working at companies of any size.
Learn more »