Skip to main content

UINT64

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

Syntax​

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

Remarks​

  • If the value falls outside of the UINT64 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 UINT64 representation of the FLOAT64 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 UINT64(33.3);

Response:

UINT64(33.3) [UINT64]
33

If we operate on a DATETIME whose unix representation is negative, the query errors because of the underlying signed value.

SELECT UINT64(DATETIME("1677-09-21 00:00:00"));

Response:

The provided value overflows UINT64