Date & Time

WEEK

Snowflake

Mengekstrak nomor minggu dalam tahun dari date atau timestamp.

Tipe hasil: NUMBERDiperbarui: 6 Jan 2026

Syntax

SQL

WEEK(date_or_timestamp)

date_or_timestampDATE/TIMESTAMPwajib

Nilai tanggal atau timestamp

SQL

1 SELECT WEEK('2024-03-15'::DATE) as week_num;

Mengekstrak nomor minggu.

Hasil

SQL

1 SELECT YEAR(order_date) as year, WEEK(order_date) as week, SUM(amount) as total
2 FROM orders
3 GROUP BY 1, 2;

Agregasi per minggu.

1	SELECT YEAR(order_date) as year, WEEK(order_date) as week, SUM(amount) as total
2	FROM orders
3	GROUP BY 1, 2;