Math

ACOS

MySQL

Menghitung arc cosine (inverse cosine) dari nilai. Hasilnya dalam radian, range 0 hingga π.

Tipe hasil: DOUBLEDiperbarui: 7 Jan 2026

Syntax

SQL

ACOS(x)

Parameter

xDOUBLEwajib

Nilai antara -1 dan 1

Contoh Penggunaan

Arc Cosine of 1

SQL

1 SELECT ACOS(1) AS acos_1;

Arc cosine dari 1 = 0 radian.

Hasil

acos_1: 0

Get PI Value

SQL

1 SELECT ACOS(-1) AS pi_value;

Arc cosine dari -1 = π.

Hasil

pi_value: 3.141592653589793

Great Circle Distance

SQL

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

Formula Haversine untuk jarak koordinat.

Hasil

(distance in km)

Fungsi Equivalen di Database Lain

ACOS

Snowflake

ACOS

BigQuery

Fungsi Terkait

SINCOSTANASINATANATAN2DEGREESRADIANSCOT

Kembali ke MySQL Functions

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