Firebird 2.5

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

venerdì 22 Gennaio 2016, 22:35


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:

Scoprite cosa possiamo fare per il vostro business
Tecnologie e Partner