Archives of the TeradataForum
Message Posted: Thu, 17 May 2001 @ 11:10:03 GMT
Has anyone ever tried to calculate the Great Circle Distance (GCD) using SQL? GCD is the distance between to places.
GCD can be calculated using the lattitude and logitude of two places as follows:
GCD = 60 * arccos[ sin(Lat1)*sin(Lat2) +
I know 4. something will have trig functions - but if someone has worked it out without them, I would be most appreciative.
Spirit Lake Consulting Pty. ltd.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|