{ “title”: “ST_Y”, “language”: “en” }

Description

When point is a valid POINT type, return the corresponding y-coordinate value

ST_Y( <point>)

Parameters

ParametersInstructions
<point>The geometric coordinates of a two-dimensional point

Return Value

Y value in geometric coordinates

Examples

SELECT ST_Y(ST_Point(24.7, 56.7));

+----------------------------+
| st_x(st_point(24.7, 56.7)) |
+----------------------------+
|                       24.7 |
+----------------------------+