Skip to main content

INT64

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

Syntax​

INT64 ( 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 INT64 representation of the value provided.

Remarks​

  • If the value falls outside of the INT64 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 INT64 representation of 33.3. Without data type context, numeric values are interpreted as their largest datatype. In this example, because 33.3 is a floating point number it's interpreted as a FLOAT64.

SELECT INT64(33.3);

Response:

INT64(33.3) [INT64]
33