GEOGRAPHY_LONGITUDE
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. 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 | +--------------------+