Date & Time

LAST_DAY

MySQL

Mengembalikan tanggal hari terakhir dari bulan untuk tanggal yang diberikan.

Tipe hasil: DATE

Syntax

SQL

LAST_DAY(date)

Parameter

dateDATE/DATETIMEwajib

Tanggal referensi

Contoh Penggunaan

Last Day of Month

SQL

1 SELECT LAST_DAY('2024-02-15') AS last_day;

Hari terakhir Februari 2024 (leap year).

Hasil

last_day: 2024-02-29

End of Current Month

SQL

1 SELECT LAST_DAY(CURDATE()) AS month_end;

Hari terakhir bulan ini.

Hasil

month_end: 2024-01-31

Monthly Report Range

SQL

1 SELECT DATE_FORMAT(order_date, '%Y-%m-01') AS month_start,
2        LAST_DAY(order_date) AS month_end,
3        COUNT(*) AS orders
4 FROM orders
5 GROUP BY DATE_FORMAT(order_date, '%Y-%m');

Range untuk laporan bulanan.

Hasil

(monthly order counts with date ranges)

Fungsi Equivalen di Database Lain

LAST_DAY

Snowflake

LAST_DAY

BigQuery

Kembali ke MySQL Functions

1	SELECT DATE_FORMAT(order_date, '%Y-%m-01') AS month_start,
2	LAST_DAY(order_date) AS month_end,
3	COUNT(*) AS orders
4	FROM orders
5	GROUP BY DATE_FORMAT(order_date, '%Y-%m');