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.
GEOGRAPHY_ LATITUDE
On this page
This function extracts the latitude portion of a GeographyPoint
.
Syntax
GEOGRAPHY_LATITUDE ( point )
Arguments
-
Any valid
GeographyPoint
or WKT string.
Return Type
A float of the latitude value.
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.
Last modified: February 24, 2023