Returns the x coordinate of the ST_Geometry value.
ST_X(geo1)
geo1
ST_Geometry
The ST_Geometry value to determine the x value of.
DOUBLE Returns the x coordinate of the ST_Geometry value.
SQL/MM (ISO/IEC 13249-3: 2006) 6.1.3
The following example returns the result 10.0.
10.0
SELECT ST_X(ST_Point(10.0,20.0,4326))