cast(… as <target>)
integer
or int
(these support 38 decimal digits (>127 bit) on this platform)E011-01, “INTEGER
and SMALLINT
data types (including all spellings)”
Other integer data types: smallint
, integer
/int
.
ISO/IEC 9075-2:2023 does not define a precision for bigint
.0 The bit support table above requires support for at least 64 signed bits (correspond to the data type mappings for the C programming language).1
The data type bigint
belongs to the optional feature T071, “BIGINT
data type”, which first appeared in ISO/IEC 9075-2:2003.2
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 »
ISO/IEC 9075-2:2016 §6.1 SR 30
ISO/IEC 9075-2:2023 §13.5 together with ISO/IEC 9899:2017, §5.2.4.2.1 Sizes of integer types <limits.h>
SQL:2003 Has Been Published (SIGMOD Record, Vol. 33, No. 1, March 2004)