GEOGRAPHY_LATITUDE
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. If the object is invalid or not a point (say a path or polygon), returns NULL.
Examples
SELECT GEOGRAPHY_LATITUDE("POINT(-73.94990499 40.69150746)") AS lat; **** +------------------+ | lat | +------------------+ | 40.6915074632948 | +------------------+