LATITUDE()

Documentation

LATITUDE() — Returns the latitude of a GEOGRAPHY_POINT value.

LATITUDE( point )

The LATITUDE() function returns the latitude, as a floating point value, from a GEOGRAPHY_POINT expression.

The following example returns all ships that are located in the northern hemisphere by examining the latitude of their current location.

SELECT ship.number, ship.country FROM ship
   WHERE LATITUDE(ship.location) > 0;