Math
MySQL
ATAN2
Menghitung arc tangent dari y/x dengan mempertimbangkan kuadran. Hasilnya dalam radian, range -π hingga π.
Tipe hasil:
DOUBLEDiperbarui: 7 Jan 2026Syntax
SQL
ATAN2(y, x)Parameter
yDOUBLEwajib
Koordinat Y
xDOUBLEwajib
Koordinat X
Contoh Penggunaan
Basic ATAN2
SQL
1 SELECT DEGREES(ATAN2(1, 1)) AS angle;
Sudut ke titik (1,1) = 45 derajat.
Hasil
angle: 45
Full Circle Angle
SQL
1 SELECT DEGREES(ATAN2(-1, -1)) AS angle;
Sudut ke titik (-1,-1) = -135 derajat.
Hasil
angle: -135
Calculate Bearing
SQL
1 SELECT DEGREES(ATAN2( 2 SIN(RADIANS(lon2-lon1)) * COS(RADIANS(lat2)), 3 COS(RADIANS(lat1)) * SIN(RADIANS(lat2)) - 4 SIN(RADIANS(lat1)) * COS(RADIANS(lat2)) * COS(RADIANS(lon2-lon1)) 5 )) AS bearing;
Menghitung bearing antara dua koordinat.
Hasil
(bearing in degrees)