MSSQLDate/Time FunctionsEOMONTH
DATEFROMPARTS

EOMONTHDate/Time Functions

FORMAT

Returns the last day of the month (or n months later).

Syntax

EOMONTH(date [, n])

Example

Enter values below to update the example in real time.

month_end
-- 이번 달 마지막 날
SELECT EOMONTH(GETDATE()) AS month_end;