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:2016-2 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:2003.2
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 any size.
Learn more »
ISO/IEC 9075:2016, Part 2, §6.1 <data type>, Syntax Rule 28
ISO/IEC 9075:2016, Part 2, §13.5 Data type correspondences 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)