How to get first and last day of previous month (with timestamp) in SQL Server

by 
select DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE())-1, 0) --First day of previous month
select DATEADD(MONTH, DATEDIFF(MONTH, -1, GETDATE())-1, -1) --Last Day of previous month

More Related Contents:

  1. Sql Server string to date conversion
  2. How to convert SQL Server’s timestamp column to datetime format
  3. How can I truncate a datetime in SQL Server?
  4. What is the significance of 1/1/1753 in SQL Server?
  5. How to get Time from DateTime format in SQL?
  6. How to remove the time portion of a datetime value (SQL Server)?
  7. SQL – The conversion of a varchar data type to a datetime data type resulted in an out-of-range value
  8. Date conversion and culture: Difference between DATE and DATETIME
  9. SQL Query to find the last day of the month
  10. Handling date in SQL Server
  11. How can I get the sum of multiple datetime values?
  12. Comparing dates stored as varchar
  13. Add default value of datetime field in SQL Server to a timestamp
  14. Best way to store time (hh:mm) in a database
  15. Retrieving the date in SQL Server; CURRENT_TIMESTAMP vs GetDate()
  16. SQL Server Group by Count of DateTime Per Hour?
  17. Why SQL Server DATETIME type saves time in ticks of 1/300 of a sec?
  18. SQL Server: convert ((int)year,(int)month,(int)day) to Datetime [duplicate]
  19. Convert a string with ‘YYYYMMDDHHMMSS’ format to datetime
  20. Convert UTC Milliseconds to DATETIME in SQL server
  21. How does SQL Server decide format for implicit datetime conversion?
  22. Undesired rounding of DateTime in SQL Server
  23. How to convert text column to datetime in SQL
  24. How to calculate difference in hours (decimal) between two dates in SQL Server?
  25. Comma separated results in SQL
  26. Which are more performant, CTE or temporary tables?
  27. Defining a one-to-one relationship in SQL Server
  28. Can you call a webservice from TSQL code?
  29. How to safely use reserved SQL names?
  30. SSRS report definition is newer than Server

Leave a Comment