Finding First and Last Day of Month on Current Day in SQL Server

Hello to everyone,

In this article, I will give information about how to find the first and last day of the current month in SQL Server.

In SQL Server in some cases we may want to get the first and last days of the month for the current day.

You can easily do this using the code below.

DECLARE @DATE DATETIME;
SET @DATE = '2021.10.19';
SELECT @DATE AS GIVENDATE,
       @DATE - DAY(@DATE) + 1 AS FIRSTDAYOFDATE,
       EOMONTH(@DATE) AS LASTDAYOFMONTHDATE;

When you run the code, you will get a result similar to the one below.

As can be seen, the first and last day information of the current month has been brought.

Good luck to everyone in business and life.