ST_Y

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

Signatures

ST_Y(A: Geography)

Geography

required

The input point Geography.

The latitude, or NULL.

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

40.7484

⌘I