All Products
Search

This Product

    ApsaraDB RDS:ST_AsInt

    Document Center

    ApsaraDB RDS:ST_AsInt

    Last Updated:Mar 28, 2026

    Converts an H3 geographic grid object into its bigint integer representation.

    Syntax

    bigint ST_AsInt(h3grid grid);

    Parameters

    ParameterDescription
    gridThe H3 geographic grid object to convert.

    Examples

    The following example converts a binary-encoded H3 grid object to a bigint value using st_h3frombinary as the input.

    SELECT st_asint(st_h3frombinary('\x010100ffff9f6826a18408'));

    Output:

          st_asint
--------------------
 613792635565375487