15.10 - SphericalDistance - Teradata Database

Teradata Database SQL Geospatial Types

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1181-151K

Returns the spherical distance, in meters, between two spherical coordinates on the planet using the Haversine Formula.

See also “ST_SphericalDistance” on page 108.

 

Argument …

Specifies …

lat1,
lon1

the latitude and longitude of the first point on the planet.

The data type of lat1 and lon1 is FLOAT.

lat2,
lon2

the latitude and longitude of the second point on the planet.

The data type of lat2 and lon2 is FLOAT.

Returns a FLOAT value.

   SELECT SYSSPATIAL.SphericalDistance(10, 20, 20, 30);