Date & Time

YEAR

DuckDB

Mengekstrak komponen tahun dari tanggal atau timestamp. Shortcut dari EXTRACT(YEAR FROM date).

Tipe hasil: INTEGERDiperbarui: 6 Jan 2026

Syntax

SQL

YEAR(date)

Parameter

dateDATE/TIMESTAMPwajib

Tanggal atau timestamp yang akan diambil tahunnya

Contoh Penggunaan

Mengambil Tahun dari Tanggal

SQL

1 SELECT
2   order_date,
3   YEAR(order_date) as order_year
4 FROM orders
5 LIMIT 3;

Mengekstrak tahun dari tanggal order.

Hasil

order_date	order_year
2024-06-15	2024
2023-12-20	2023
2024-01-05	2024

Aggregasi per Tahun

SQL

1 SELECT
2   YEAR(sale_date) as year,
3   SUM(amount) as total_sales,
4   COUNT(*) as transaction_count
5 FROM sales
6 GROUP BY YEAR(sale_date)
7 ORDER BY year;

Menghitung total penjualan per tahun.

Hasil

year	total_sales	transaction_count
2022	5000000000	12500
2023	7500000000	18200
2024	3200000000	8500

Filter Data Tahun Tertentu

SQL

1 SELECT *
2 FROM invoices
3 WHERE YEAR(invoice_date) = 2024
4   AND YEAR(due_date) = 2024;

Mencari invoice yang dibuat dan jatuh tempo di tahun 2024.

Hasil

invoice_id	invoice_date	due_date	amount
INV001	2024-01-15	2024-02-15	5000000
INV002	2024-03-20	2024-04-20	7500000

Fungsi Terkait

EXTRACTDATE_PARTMONTHDAYHOURMINUTESECONDQUARTERWEEK

Kembali ke DuckDB Functions

1	SELECT
2	order_date,
3	YEAR(order_date) as order_year
4	FROM orders
5	LIMIT 3;

1	SELECT
2	YEAR(sale_date) as year,
3	SUM(amount) as total_sales,
4	COUNT(*) as transaction_count
5	FROM sales
6	GROUP BY YEAR(sale_date)
7	ORDER BY year;

1	SELECT *
2	FROM invoices
3	WHERE YEAR(invoice_date) = 2024
4	AND YEAR(due_date) = 2024;