Date & Time

YEAR

Snowflake

Mengekstrak komponen tahun dari date atau timestamp.

Tipe hasil: NUMBERDiperbarui: 6 Jan 2026

Syntax

SQL

YEAR(date_or_timestamp)

date_or_timestampDATE/TIMESTAMPwajib

Nilai tanggal atau timestamp

SQL

1 SELECT YEAR('2024-03-15'::DATE) as year;

Mengekstrak tahun.

Hasil

2024

SQL

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

Agregasi per tahun.

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