Get the last day of the month in SQL

by

From SQL Server 2012 you can use the EOMONTH function.

Returns the last day of the month that contains the specified date,
with an optional offset.

Syntax

EOMONTH ( start_date [, month_to_add ] )

How … I can find the last day of the month for any given date?

SELECT EOMONTH(@SomeGivenDate)

More Related Contents:

  1. How to generate a range of numbers between two numbers?
  2. How to select all records from one table that do not exist in another table?
  3. SET versus SELECT when assigning variables?
  4. Avoid duplicates in INSERT INTO SELECT query in SQL Server
  5. How do you list the primary key of a SQL Server table?
  6. Calculating distance between two points (Latitude, Longitude)
  7. Add Foreign Key relationship between two Databases
  8. SQL Server check case-sensitivity?
  9. How to update Identity Column in SQL Server?
  10. How to assign an exec result to a sql variable?
  11. Concatenate values based on ID
  12. Query error with ambiguous column name in SQL
  13. Why (and how) to split column using master..spt_values?
  14. Splitting delimited values in a SQL column into multiple rows
  15. SQL: parse the first, middle and last name from a fullname field
  16. Why and when a LEFT JOIN with condition in WHERE clause is not equivalent to the same LEFT JOIN in ON? [duplicate]
  17. varbinary to string on SQL Server
  18. Scope of temporary tables in SQL Server
  19. How can I include null values in a MIN or MAX?
  20. SQL Server 2005 ROW_NUMBER() without ORDER BY
  21. Can an INNER JOIN offer better performance than EXISTS
  22. Find the real column name of an alias used in a view?
  23. Stored procedure that exports data into csv files only exports to one file
  24. Get Start and End Date from Week Number SQL Server
  25. How to get the identity of an inserted row?
  26. Getting Dates between a range of dates
  27. The most elegant way to generate permutations in SQL server
  28. MAX vs Top 1 – which is better?
  29. How to get Previous Value for Null Values
  30. CONCAT_WS() for SQL Server

Leave a Comment