t-sql first day of previous month

If you are after T-SQL First Day of Previous Month calculation then you are in the right place.

To return first day of previous month using T-SQL we can use the following statement:

Below is a visual representation of the logic I want to use to get first day of previous month and below the picture is the explanation.

First Day of Previous month

1) Our today's date is 20th of Feb. We substract number of days in the month from our date (20) and we get last day of previous month.
2) We add one day to get first day of current month.
3) We go one month back so first day of the month stays the same and Feb changes to Jan.

Now the code:

SELECT DATEADD(m,-1, Dateadd(d,1-DATEPART(d,getdate()),GETDATE())) AS [First Day of Previous Month]

The result of this T-SQL statement is first day of previous month.

Hope that helps!
Katie

Did you find this page useful? +3  |  -0
(3 Votes)

it works accurately
Want to add a comment


no comments

We had our legal consultation, and today we'll send our request to create a 'not for profit' company, to companies house.

£5,000 is our first target to cover basic operational costs, investments and salary for next 2-3 months.

just 11 days left
£867 ($1,140)
raised of £5,000 target
17%
raised


Sharing is caring :)
Pawel Olejniczak donated £20
Thomas Tabert donated $10
 Katrina Kilcoyne donated £20
 Jason Batters donated £20

Official Sponsors