Date & Time

WEEKOFYEAR

MySQL

Mengembalikan nomor minggu kalendar (1-53) dengan standar ISO. Setara dengan WEEK(date, 3).

Tipe hasil: INTEGERDiperbarui: 7 Jan 2026

Syntax

SQL

WEEKOFYEAR(date)

Parameter

datedatewajib

Tanggal yang akan diambil nomor minggunya

Contoh Penggunaan

ISO Week Number

SQL

1 SELECT WEEKOFYEAR('2024-01-01') AS iso_week;

Mendapatkan nomor minggu ISO.

Hasil

iso_week: 1

Laporan Mingguan

SQL

1 SELECT WEEKOFYEAR(sale_date) AS week,
2   YEAR(sale_date) AS year,
3   SUM(amount) AS total
4 FROM sales
5 GROUP BY year, week
6 ORDER BY year, week;

Agregasi penjualan per minggu ISO.

Hasil

(weekly sales report)

Filter Minggu Ini

SQL

1 SELECT * FROM tasks
2 WHERE WEEKOFYEAR(due_date) = WEEKOFYEAR(CURDATE())
3   AND YEAR(due_date) = YEAR(CURDATE());

Mencari task yang jatuh tempo minggu ini.

Hasil

(this week's tasks)

Fungsi Terkait

DAYOFWEEKDAYOFYEARDAYOFMONTHDAYNAMEWEEKDAY

Kembali ke MySQL Functions

1	SELECT WEEKOFYEAR(sale_date) AS week,
2	YEAR(sale_date) AS year,
3	SUM(amount) AS total
4	FROM sales
5	GROUP BY year, week
6	ORDER BY year, week;

1	SELECT * FROM tasks
2	WHERE WEEKOFYEAR(due_date) = WEEKOFYEAR(CURDATE())
3	AND YEAR(due_date) = YEAR(CURDATE());