Post New Resource

T-SQL code to get the last day of the month!

Posted By:Gowthammanju Posted Date: June 28, 2011 Points: 40 Category: SQL Query URL: http://www.dotnetspark.com

The logic behind this 'last day of the month' calculations is that you get the month part of a given date, add one to it, there by getting to the next month. Then subtract 1 day from the first of that month.

This whole Thing can be written in one line and here it is:

SELECT DAY(DATEADD(d, -DAY(DATEADD(m,1,GETDATE())),DATEADD(m,1,GETDATE())))

Related Resource From The Same Category

List of all tables in a database with number of records
Calculating probabilities for Tunisia football championship before 3 rounds
Make a month calendar with sql server
First and last day of a given week
Inner join in SQL
Update Male TO Female and Female To Male with single query
Truncate all tables sql server?
Count No of days between two dates in SQL
To Drop all Table in a Database
To Drop all Primary Key constraints in a Database

Find More code samples in C#, ASP.Net, Vb.Net and more Here

T-SQL code to get the last day of the month!

Further Readings:

Read also another Resources from the same Author

Related Resource From The Same Category