Outdated Version
You are viewing an older version of this section. View current production version.
GEOGRAPHY_LONGITUDE
This function extracts the longitude portion of a GeographyPoint.
Syntax
GEOGRAPHY_LONGITUDE ( point )
Arguments
- Any valid
GeographyPointor WKT string.
Return Type
A float of the longitude value. If the object is invalid or not a point (say a path or polygon), returns NULL.
Examples
select geography_longitude("POINT(-73.94990499 40.69150746)") as lon;
+--------------------+
| lon |
+--------------------+
| -73.94990499066743 |
+--------------------+
