MySQLDate/Time FunctionsLAST_DAY
TIMESTAMPDIFF

LAST_DAYDate/Time Functions

DAYOFWEEK

Returns the last day of the month.

Syntax

LAST_DAY(date)

Example

Enter values below to update the example in real time.

month_end
-- 이번 달 마지막 날
SELECT LAST_DAY(CURDATE()) AS month_end;