PHP-Code:with x as (
SELECT DATEI.*,
Cast(6378,388*
(ACOS(SIN(51.130546*PI()/180)* SIN(XKO*PI()/180) +
COS(51.130546*PI()/180)*COS(XKO*PI()/180)* COS((8.120452
-YKO)*PI()/180))) as dec(10, 4))
AS DISTANCE
FROM DATEI
)
Select x.* from x where DISTANCE < 10 ORDER BY DISTANCE DESC
![[NEWSboard IBMi Forum]](images/duke/nblogo.gif)



Mit Zitat antworten

Bookmarks