This function is used to cast data to the
INT8 data type.
INT8 ( arg )
The value to be cast. The value has to be of a Numeric or Date & Time data type category.
INT8 representation of the value provided.
- If the value falls outside of the
INT8range, 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
INT8 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
INT8 the query errors.
The provided value overflows INT8