This function is used to cast data to the
INT16 data type.
INT16 ( arg )
The value to be cast. The value has to be of a Numeric or Date & Time data type category.
INT16 representation of the value provided.
- If the value falls outside of the
INT16range, an overflow error is returned.
- Date & Time values are first converted to their underlying unix representation before being converted.
- Conversions from floating point numbers floor the value.
This returns the
INT16 representation of -1. Without data type context, numeric values are interpreted
as their largest datatype. In this example, because -1 is signed it's interpreted as an
If we operate on a values that exceeds the range of
INT16 the query errors.
The provided value overflows INT16