Getting the First Date of the Current Month in SQL Server

In SQL Server, you can get the first date of the current month using the `DATEFROMPARTS` function and the `GETDATE()` function. Here's how to do it.

Syntax

The syntax to get the first date of the current month is as follows:

SELECT DATEFROMPARTS(YEAR(GETDATE()), MONTH(GETDATE()), 1) AS FirstDateOfMonth; 

This query returns the first date of the current month.

Example

Let's say we want to get the first date of the current month:

SELECT DATEFROMPARTS(YEAR(GETDATE()), MONTH(GETDATE()), 1) AS FirstDateOfMonth; 

This query will return the result:

The result shows that the first date of the current month (March 2023) is '2023-03-01'.

Alternative Syntax

You can also use the following alternative syntax to get the first date of the current month:

SELECT CAST(DATEADD(mm, DATEDIFF(mm, 0, GETDATE()), 0) AS DATE) AS FirstDateOfMonth; 

This syntax uses the `DATEADD` function to add the difference between the current month and the base date (0) to the base date, and then casts the result to a date.

Using a Variable

If you want to store the first date of the current month in a variable, you can use the following syntax:

DECLARE @FirstDateOfMonth DATE; SET @FirstDateOfMonth = DATEFROMPARTS(YEAR(GETDATE()), MONTH(GETDATE()), 1); SELECT @FirstDateOfMonth; 

This query declares a variable `@FirstDateOfMonth` and sets it to the first date of the current month using the `DATEFROMPARTS` function.