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