Extracts the longitude coordinate of a GEOGRAPHY Point. Returns NULL for empty geography objects. Returns an error if the input is not a single Point (and not an empty GEOGRAPHY object).

​
Syntax

ST_X(<object>)

​
Parameters

ParameterDescriptionSupported input types
<object>The GEOGRAPHY Point to extract the longitude of.GEOGRAPHY

​
Return Type

ST_X returns a value of type DOUBLE PRECISION.

​
Example

The following code example constructs a Point in the GEOGRAPHY data type from longitude and latitude coordinates and extracts its longitude coordinate:

SELECT ST_X(ST_GEOGPOINT(-73.98551041593687, 40.75793403395676)) AS result

Returns

result (DOUBLE PRECISION)
-73.98551041593687