Date & Time

DAYOFWEEK

MySQL

Mengembalikan indeks hari dalam minggu dari tanggal. Menggunakan konvensi 1=Sunday, 2=Monday, dst, 7=Saturday (standar ODBC).

Tipe hasil: INTEGERDiperbarui: 7 Jan 2026

Syntax

SQL

DAYOFWEEK(date)

Parameter

datedatewajib

Tanggal yang akan diambil indeks harinya

Contoh Penggunaan

Indeks Hari

SQL

1 SELECT DAYOFWEEK('2024-01-15') AS dow;

Senin adalah hari ke-2 dalam DAYOFWEEK.

Hasil

dow: 2

Filter Hari Kerja

SQL

1 SELECT * FROM schedules
2 WHERE DAYOFWEEK(work_date) BETWEEN 2 AND 6;

Mencari jadwal hari kerja (Senin-Jumat).

Hasil

(weekday schedules)

Cek Weekend

SQL

1 SELECT order_id,
2   CASE DAYOFWEEK(order_date)
3     WHEN 1 THEN 'Sunday'
4     WHEN 7 THEN 'Saturday'
5     ELSE 'Weekday'
6   END AS day_type
7 FROM orders;

Menandai tipe hari untuk setiap order.

Hasil

(orders with day type)

Fungsi Equivalen di Database Lain

DAYOFWEEK

Snowflake

DAYOFWEEK

DuckDB

Fungsi Terkait

DAYOFYEARDAYOFMONTHDAYNAMEWEEKDAYWEEKOFYEAR

Kembali ke MySQL Functions

1	SELECT * FROM schedules
2	WHERE DAYOFWEEK(work_date) BETWEEN 2 AND 6;

1	SELECT order_id,
2	CASE DAYOFWEEK(order_date)
3	WHEN 1 THEN 'Sunday'
4	WHEN 7 THEN 'Saturday'
5	ELSE 'Weekday'
6	END AS day_type
7	FROM orders;