Outdated Version
You are viewing an older version of this section. View current production version.
GEOGRAPHY_LATITUDE
This function extracts the latitude portion of a GeographyPoint.
Syntax
GEOGRAPHY_LATITUDE ( point )
Arguments
- Any valid
GeographyPointor 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 |
+------------------+
