Math

ATAN2

MySQLMySQL

Menghitung arc tangent dari y/x dengan mempertimbangkan kuadran. Hasilnya dalam radian, range -π hingga π.

Tipe hasil: DOUBLEDiperbarui: 7 Jan 2026

Syntax

SQL
ATAN2(y, x)

Parameter

yDOUBLEwajib

Koordinat Y

xDOUBLEwajib

Koordinat X

Contoh Penggunaan

Basic ATAN2

SQL
1SELECT DEGREES(ATAN2(1, 1)) AS angle;

Sudut ke titik (1,1) = 45 derajat.

Hasil
angle: 45

Full Circle Angle

SQL
1SELECT DEGREES(ATAN2(-1, -1)) AS angle;

Sudut ke titik (-1,-1) = -135 derajat.

Hasil
angle: -135

Calculate Bearing

SQL
1SELECT 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)

Fungsi Equivalen di Database Lain