ST_X extracts the longitude from a geography object of the POINT type.
Syntax
DOUBLE ST_X(GEOGRAPHY <value>)Parameters
value: Required. A geography object of the POINT type. Use the ST_GEOGPOINT, ST_GEOGFROMWKB, or ST_GEOGFROMTEXT function to create this object.
Return value
Returns the longitude as a DOUBLE value.
Examples
SELECT ST_X(ST_GEOGPOINT(1, 4));
-- Returns:
+------------+
| _c0 |
+------------+
| 1.0 |
+------------+
SELECT ST_X(ST_GEOGFROMTEXT('POINT (10 20)'));
-- Returns:
+------------+
| _c0 |
+------------+
| 10.0 |
+------------+
SELECT ST_X(ST_GEOGFROMWKB(x'000000000140000000000000004010000000000000'));
-- Returns:
+------------+
| _c0 |
+------------+
| 2.0 |
+------------+