unsigned
or signed
integer
instead (supports 38 decimal digits on this platform)int64
insteadThe SQL cast
specification converts a value to the named data type.
SELECT CAST(column_name AS BIGINT
)
FROM …
Bigint
in other places: column type.
Product specific cast functions: try_cast
, safe_cast
, ::
, convert
.
ISO/IEC 9075-2:2023 defines integer
(E011-01, “INTEGER
and SMALLINT
data types (including all spellings)”) and the cast
specification (F201).
You can’t catch up on 20 years of SQL evolution in one day. Subscribe the newsletter via E-Mail, Twitter or RSS to gradually catch up and to keep modern-sql.com on your radar.
The essence of SQL tuning in 200 pages
Buy now!
(paperback and/or PDF)
Paperback also available at Amazon.com.
Markus offers SQL training and consulting for developers working at companies of all sizes.
Learn more »