Showing results for 
Search instead for 
Did you mean: 
Community Team Member
Community Team Member
SQL code to find the distance between two lat-long points on a globe.

Additional information can be found here:
Calculating Distance Between Data Centers on a Globe
2 * 3960 * asin(sqrt((sin(radians(([latitude_2] - [latitude_1]) / 2)))

   ^ 2 + cos(radians([latitude_1])) * cos(radians([latitude_2]))

   * (sin(radians(([longitude_2] - [longitude_1]) / 2)))^ 2))
Version history
Last update:
‎03-02-2023 08:58 AM
Updated by:
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email [email protected]

Share this page: