15.5.2 distance(lat1, long1, lat2, long2,SRID)

Function Returns distance between lat1/long1 and lat2/long2, default SRID is 8307.

Value 1: Latitude1 - Value can be one of the following types: number, double, float.

Value 2: Longitude1 - Value can be one of the following types: number, double, float.

Value 3: Latitude2 - Value can be one of the following types: number, double, float.

Value 4: Longitude2 - Value can be one of the following types: number, double, float.

Value 5: SRID - Value can be one of the following types: integer.

Returned value will be of type double.

Function Result

distance(37.78371333337545, -122.4052500001069, 37.78371333337545, 37.78371333337545, 8307)

1.1394718018250743E7