ST_X

docs/en/sql-reference/sql-functions/spatial-functions/st_x.md

4.1.0394 B

ST_X

If point is of a valid Point type, return the corresponding X-coordinate value.

Syntax

Haskell

DOUBLE ST_X(POINT point)

Examples

Plain

MySQL > SELECT ST_X(ST_Point(24.7, 56.7));
+----------------------------+
| st_x(st_point(24.7, 56.7)) |
+----------------------------+
|                       24.7 |
+----------------------------+

keyword

ST_X,ST,X