GEOGRAPHY_LATITUDE

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

SELECT GEOGRAPHY_LATITUDE("POINT(-73.94990499 40.69150746)") AS lat;

+------------------+
| lat              |
+------------------+
| 40.6915074632948 |
+------------------+

Related Topics

For more information about working with geospatial data, see Working with Geospatial Features.