deeejay icon

SQL to calculate distance between LAT LONG

deeejay | PRO | 11/20/15 11:31:19 PM UTC | 0 ⭐ | 276 👁️ | Never ⏰ | []
SQL |

410 B

|

None

|

0 👍

/

0 👎

Raw Download Clone Embed Print View 
[Longitude OF START point] may have TO manually enter
[Lattitude OF START point] may have TO manually enter
 
[latitude] USE latitude FROM DATA SET
[longitude] USE FROM DATA SET
 
 
ACOS( SIN([Longitude OF START point]*PI()/180)*SIN([latitude]*PI()/180) + COS([Longitude OF START point]*PI()/180)*COS([latitude]*PI()/180)*COS([longitude]*PI()/180-([Lattitude OF START point])*PI()/180) ) * ((6371*2)/3) AS [Distance]

Comments