SQLSERVER takes the first and last days of the current month

-- First day of the month: selectdateadd (dd,-day (getdate () + 1, getdate () -- last day of the month: SELECTdateadd (MS,-3, DATEADD (mm, DATEDIFF (m, 0, getdate () + 1, 0) -- First day of last month: selectCONVERT (int, CONVERT (varchar (10), DATEADD (m,-1, dateadd (dd, -day (getdate () + 1, g

-- First day of the month: selectdateadd (dd,-day (getdate () + 1, getdate () -- last day of the month: SELECTdateadd (MS,-3, DATEADD (mm, DATEDIFF (m, 0, getdate () + 1, 0) -- First day of last month: select CONVERT (int, CONVERT (varchar (10), DATEADD (m,-1, dateadd (dd,-day (getdate () + 1, g

-- The first day of this month:

Select dateadd (dd,-day (getdate () + 1, getdate ())

-- Last day of the month:

SELECT dateadd (MS,-3, DATEADD (mm, DATEDIFF (m, 0, getdate () + 1, 0 ))

-- First day of last month:

Select CONVERT (int, CONVERT (varchar (10), DATEADD (m,-1, dateadd (dd,-day (getdate () + 1, getdate ())), 112 ))

-- Last day of last month:

Select convert (int, convert (varchar (10), dateadd (d,-1, dateadd (m,-1, DATEADD (mm, DATEDIFF (m, 0, getdate ()) + 1, 0), 112 ))

Appendix: http://www.w3school.com.cn/ SQL/SQL _dates.asp