Date & Time

YEAR

MySQL

Mengekstrak tahun dari tanggal. Mengembalikan nilai 1000-9999.

Tipe hasil: INTEGERDiperbarui: 7 Jan 2026

Syntax

SQL

YEAR(date)

datedatewajib

Tanggal yang akan diambil tahunnya

SQL

1 SELECT YEAR('2024-01-15') AS year;

Mengambil tahun dari tanggal.

Hasil

year: 2024

SQL

1 SELECT YEAR(order_date) AS year,
2        SUM(total) AS yearly_sales
3 FROM orders
4 GROUP BY YEAR(order_date);

Menghitung total penjualan per tahun.

Hasil

year: 2024, yearly_sales: 1000000

SQL

1 SELECT * FROM events
2 WHERE YEAR(event_date) = YEAR(CURDATE());

Mencari event tahun ini.

Hasil

(this year's events)

YEAR

Snowflake

YEAR

DuckDB

1	SELECT YEAR(order_date) AS year,
2	SUM(total) AS yearly_sales
3	FROM orders
4	GROUP BY YEAR(order_date);

1	SELECT * FROM events
2	WHERE YEAR(event_date) = YEAR(CURDATE());