The Haversine formula in Firebird SQL => Calculate distance between two WGS84 Points


I think might be helpful, today for a customer i do the Haversine formulas for Firebird Sql as a stored procedure.

This formula allow you to calculate the distance in meter between two WGS84 datum points(degree points of Earth).

You can call the procedure like this:

The result wil be aprox 14Km, the distance from my office and my house aprox.

the parameters of the procedure are:

The procedure code is:

This post is also available in: Inglese

Scoprite cosa possiamo fare per il vostro business
I nostri linguaggi