SELECT
6378.138 * 2 * ASIN(
SQRT(
POW(
SIN(
(
36.082551 * PI() / 180 - 36.076996 * PI() / 180
) / 2
), 2
) + COS(36.082551* PI() / 180) * COS(36.076996 * PI() / 180) * POW(
SIN(
(
103.873124 * PI() / 180 - 103.770481 * PI() / 180
) / 2
), 2
)
)
) AS distance
HAVING distance <=1500
经纬度计算相差的公里数
最新推荐文章于 2023-09-27 11:15:39 发布