GEOGRAPHY_ LONGITUDE
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
On this page
This function extracts the longitude portion of a GeographyPoint
.
Syntax
GEOGRAPHY_LONGITUDE ( point )
Arguments
-
Any valid
GeographyPoint
or WKT string.
Return Type
A float of the longitude value.
Examples
SELECT GEOGRAPHY_LONGITUDE("POINT(-73.94990499 40.69150746)") AS lon;
+--------------------+
| lon |
+--------------------+
| -73.94990499066743 |
+--------------------+
Related Topics
For more information about working with geospatial data, see Working with Geospatial Features.
Last modified: February 24, 2023