cast(… as <target>)
. Use cast(… as signed)
Other integer data types: bigint
.
ISO/IEC 9075:2016-2 does not define a precision for these data types.0 The bit numbers above correspond to the data type mappings for the C programming language.1
The data types smallint
, integer
and int
where already required for Entry SQL-92.
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>