You are viewing an older version of this section. View current production version.
Join the MemSQL Community Today
Get expert advice, develop skills, and connect with others.

GEOGRAPHY_LATITUDE

This function extracts the latitude portion of a GeographyPoint.

Syntax

GEOGRAPHY_LATITUDE ( point )

Arguments

  • Any valid GeographyPoint or WKT string.

Return Type

A float of the latitude value. If the object is invalid or not a point (say a path or polygon), returns NULL.

Examples

memsql> select geography_latitude("POINT(-73.94990499 40.69150746)") as lat;
+------------------+
| lat              |
+------------------+
| 40.6915074632948 |
+------------------+