Date & Time

WEEK

DuckDB

Mengekstrak nomor minggu dalam tahun dari tanggal (1-53). Menggunakan standar ISO week numbering.

Tipe hasil: INTEGERDiperbarui: 6 Jan 2026

Syntax

SQL

WEEK(date)

Parameter

dateDATE/TIMESTAMPwajib

Tanggal yang akan diambil nomor minggunya

Contoh Penggunaan

Mendapatkan Nomor Minggu

SQL

1 SELECT
2   sale_date,
3   WEEK(sale_date) as week_num,
4   YEAR(sale_date) as year
5 FROM sales
6 WHERE sale_date >= '2024-01-01'
7 LIMIT 5;

Mengekstrak nomor minggu dari tanggal penjualan.

Hasil

sale_date	week_num	year
2024-01-01	1	2024
2024-01-08	2	2024
2024-01-15	3	2024

Weekly Sales Report

SQL

1 SELECT
2   YEAR(sale_date) as year,
3   WEEK(sale_date) as week,
4   SUM(amount) as weekly_sales,
5   COUNT(*) as transaction_count
6 FROM sales
7 WHERE sale_date >= '2024-01-01'
8 GROUP BY YEAR(sale_date), WEEK(sale_date)
9 ORDER BY year, week;

Laporan penjualan mingguan.

Hasil

year	week	weekly_sales	transaction_count
2024	1	85000000	450
2024	2	92000000	520
2024	3	78000000	410

Week-over-Week Comparison

SQL

1 WITH weekly AS (
2   SELECT
3     YEAR(sale_date) as year,
4     WEEK(sale_date) as week,
5     SUM(amount) as sales
6   FROM sales
7   GROUP BY 1, 2
8 )
9 SELECT
10   year, week, sales,
11   LAG(sales) OVER (ORDER BY year, week) as prev_week,
12   ROUND((sales - LAG(sales) OVER (ORDER BY year, week)) * 100.0 /
13     LAG(sales) OVER (ORDER BY year, week), 1) as wow_growth
14 FROM weekly;

Menghitung pertumbuhan week-over-week.

Hasil

year	week	sales	prev_week	wow_growth
2024	1	85000000	NULL	NULL
2024	2	92000000	85000000	8.2
2024	3	78000000	92000000	-15.2

Fungsi Terkait

EXTRACTDATE_PARTYEARMONTHDAYHOURMINUTESECONDQUARTER

Kembali ke DuckDB Functions

1	SELECT
2	sale_date,
3	WEEK(sale_date) as week_num,
4	YEAR(sale_date) as year
5	FROM sales
6	WHERE sale_date >= '2024-01-01'
7	LIMIT 5;

1	SELECT
2	YEAR(sale_date) as year,
3	WEEK(sale_date) as week,
4	SUM(amount) as weekly_sales,
5	COUNT(*) as transaction_count
6	FROM sales
7	WHERE sale_date >= '2024-01-01'
8	GROUP BY YEAR(sale_date), WEEK(sale_date)
9	ORDER BY year, week;

1	WITH weekly AS (
2	SELECT
3	YEAR(sale_date) as year,
4	WEEK(sale_date) as week,
5	SUM(amount) as sales
6	FROM sales
7	GROUP BY 1, 2
8	)
9	SELECT
10	year, week, sales,
11	LAG(sales) OVER (ORDER BY year, week) as prev_week,
12	ROUND((sales - LAG(sales) OVER (ORDER BY year, week)) * 100.0 /
13	LAG(sales) OVER (ORDER BY year, week), 1) as wow_growth
14	FROM weekly;