Product Solutions Support
Try MemSQL

GEOGRAPHY_LONGITUDE

This function extracts the longitude portion of a GeographyPoint.

Syntax

GEOGRAPHY_LONGITUDE ( point )

Arguments

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

memsql> select geography_longitude("POINT(-73.94990499 40.69150746)") as lon;
+--------------------+
| lon                |
+--------------------+
| -73.94990499066743 |
+--------------------+
Was this article useful?