LONGITUDE()

Documentation

LONGITUDE() — Returns the longitude of a GEOGRAPHY_POINT value.

LONGITUDE( point )

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

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

SELECT ship.number, ship.country FROM ship
   WHERE LONGITUDE(ship.location) < 0
   AND  LONGITUDE(ship.location) > -180;