当月第一天:
select DATEADD(mm, DATEDIFF(m,0,GETDATE()), 0)
当月最后一天:
select DATEADD(M, DATEDIFF(m,0,GETDATE())+1, -1)
上个月第一天
select DATEADD(mm, DATEDIFF(m,0,GETDATE())-1, 0)
上个月最后一天
select DATEADD(M, DATEDIFF(m,0,GETDATE()), -1)
当月第一天:
select DATEADD(mm, DATEDIFF(m,0,GETDATE()), 0)
当月最后一天:
select DATEADD(M, DATEDIFF(m,0,GETDATE())+1, -1)
上个月第一天
select DATEADD(mm, DATEDIFF(m,0,GETDATE())-1, 0)
上个月最后一天
select DATEADD(M, DATEDIFF(m,0,GETDATE()), -1)