Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query
optimization, and usability that you won’t want to miss.
This function extracts the longitude portion of a GeographyPoint
.
GEOGRAPHY_LONGITUDE ( point )
GeographyPoint
or WKT string.A float of the longitude value. If the object is invalid or not a point (say a path or polygon), returns NULL.
SELECT GEOGRAPHY_LONGITUDE("POINT(-73.94990499 40.69150746)") AS lon;
+--------------------+
| lon |
+--------------------+
| -73.94990499066743 |
+--------------------+