ST_Y

Introduction: Returns the latitude (Y coordinate) of a point geography. Returns NULL for non-point geographies and empty points.

Format:

ST_Y (A: Geography)

Return type: Double

Since: v1.9.1

SQL Example

SELECT ST_Y(ST_GeogFromWKT('POINT (-73.9857 40.7484)'));

Output:

40.7484