Date & Time

MONTH

MySQL

Mengekstrak bulan dari tanggal. Mengembalikan nilai 1-12.

Tipe hasil: INTEGERDiperbarui: 7 Jan 2026

Syntax

SQL

MONTH(date)

datedatewajib

Tanggal yang akan diambil bulannya

SQL

1 SELECT MONTH('2024-01-15') AS month;

Mengambil bulan dari tanggal.

Hasil

month: 1

SQL

1 SELECT MONTH(order_date) AS month,
2        SUM(total) AS monthly_sales
3 FROM orders
4 WHERE YEAR(order_date) = 2024
5 GROUP BY MONTH(order_date);

Menghitung penjualan per bulan.

Hasil

month: 1, monthly_sales: 100000

SQL

1 SELECT * FROM tasks
2 WHERE MONTH(due_date) = MONTH(CURDATE())
3   AND YEAR(due_date) = YEAR(CURDATE());

Mencari tugas bulan ini.

Hasil

(this month's tasks)

MONTH

Snowflake

MONTH

DuckDB

1	SELECT MONTH(order_date) AS month,
2	SUM(total) AS monthly_sales
3	FROM orders
4	WHERE YEAR(order_date) = 2024
5	GROUP BY MONTH(order_date);

1	SELECT * FROM tasks
2	WHERE MONTH(due_date) = MONTH(CURDATE())
3	AND YEAR(due_date) = YEAR(CURDATE());