Teradata Forums / Teradata / Teradata Advanced Analytics User Group / How to calculate a distance between point a to b by using Longitude and Latitude / Latest PostsInstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comThu, 04 Dec 2008 02:00:43 GMT20RE: How to calculate a distance between point a to b by using Longitude and Latitudehttp://www.teradata.com/teradataforum/Topic11665-22-1.aspxI’m not sure whether you are asking for the formulas or just how to do it in SQL. Maybe you can provide the formula and how the data is represented and then someone could suggest a method. My suggestion would be to write a UDF or create a UDT (User Defiend Type) that contains the earth coordinates. Then you can define the user defined methods (UDMs) that operate on that data type.If you are just looking for the formulas you can google that and get all sorts of hits that might be useful to you.Thu, 29 May 2008 22:40:09 GMTrgsHow to calculate a distance between point a to b by using Longitude and Latitudehttp://www.teradata.com/teradataforum/Topic11665-22-1.aspxHi, i need help to use Teradata SQL function to calcuation a distance from point a to point b which are using Longitude and latitude.Please helps...thanks,Thu, 29 May 2008 17:42:13 GMTnguyent02