Date & Time

DAYNAME

MySQL

Mengembalikan nama hari dalam minggu dari tanggal yang diberikan. Nama dikembalikan dalam bahasa sesuai setting lc_time_names.

Tipe hasil: VARCHARDiperbarui: 7 Jan 2026

Syntax

SQL

DAYNAME(date)

Parameter

datedatewajib

Tanggal yang akan diambil nama harinya

Contoh Penggunaan

Nama Hari dari Tanggal

SQL

1 SELECT DAYNAME('2024-01-15') AS day_name;

Mengambil nama hari dari tanggal.

Hasil

day_name: Monday

Analisis Hari Kerja

SQL

1 SELECT DAYNAME(order_date), COUNT(*) AS orders
2 FROM orders
3 GROUP BY DAYNAME(order_date)
4 ORDER BY FIELD(DAYNAME(order_date), 
5   'Monday','Tuesday','Wednesday',
6   'Thursday','Friday','Saturday','Sunday');

Menghitung pesanan per hari dalam seminggu.

Hasil

(orders grouped by day name)

Filter Hari Tertentu

SQL

1 SELECT * FROM appointments
2 WHERE DAYNAME(appointment_date) 
3   IN ('Saturday', 'Sunday');

Mencari appointment di weekend.

Hasil

(weekend appointments)

Fungsi Terkait

DAYOFWEEKDAYOFYEARDAYOFMONTHWEEKDAYWEEKOFYEAR

Kembali ke MySQL Functions

1	SELECT DAYNAME(order_date), COUNT(*) AS orders
2	FROM orders
3	GROUP BY DAYNAME(order_date)
4	ORDER BY FIELD(DAYNAME(order_date),
5	'Monday','Tuesday','Wednesday',
6	'Thursday','Friday','Saturday','Sunday');

1	SELECT * FROM appointments
2	WHERE DAYNAME(appointment_date)
3	IN ('Saturday', 'Sunday');