LATITUDE()

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

Synopsis

LATITUDE( point )

Description

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

Example

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;