Math

COS

MySQL

Menghitung nilai cosinus dari sudut dalam radian. Hasilnya antara -1 dan 1.

Tipe hasil: DOUBLEDiperbarui: 7 Jan 2026

Syntax

SQL

COS(x)

Parameter

xDOUBLEwajib

Sudut dalam radian

Contoh Penggunaan

Cos of 0

SQL

1 SELECT COS(0) AS cos_0;

Cosinus dari 0 radian = 1.

Hasil

cos_0: 1

Cos of 60 Degrees

SQL

1 SELECT COS(RADIANS(60)) AS cos_60;

Cosinus dari 60 derajat = 0.5.

Hasil

cos_60: 0.5

Distance Calculation

SQL

1 SELECT 6371 * ACOS(
2   COS(RADIANS(lat1)) * COS(RADIANS(lat2)) *
3   COS(RADIANS(lon2) - RADIANS(lon1)) +
4   SIN(RADIANS(lat1)) * SIN(RADIANS(lat2))
5 ) AS distance_km
6 FROM locations;

Formula Haversine untuk jarak bumi.

Hasil

(distance in km)

Fungsi Terkait

SINTANASINACOSATANATAN2DEGREESRADIANSCOT

Kembali ke MySQL Functions

1	SELECT 6371 * ACOS(
2	COS(RADIANS(lat1)) * COS(RADIANS(lat2)) *
3	COS(RADIANS(lon2) - RADIANS(lon1)) +
4	SIN(RADIANS(lat1)) * SIN(RADIANS(lat2))
5	) AS distance_km
6	FROM locations;