ST_X

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

Parameter	Description	Supported 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