Skip to main content

INT32

This function is used to cast data to the INT32 data type.

Syntax

INT32 ( arg )  

arg
The value to be cast. The value has to be of a Numeric or Date & Time data type category.

Return Value

Returns the INT32 representation of the value provided.

Remarks

  • If the value falls outside of the INT32 range, 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.

Examples

This returns the INT32 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 INT64.

SELECT INT32(-1);

Response:

INT32(-1) [INT32]
-1

If we operate on a values that exceeds the range of INT32 the query errors.

SELECT INT32(2147483648);

Response:

The provided value overflows INT32