--定义变量
declare @BeginTime datetime = '2018-02-05'
--获得传入月份第一天
select dateadd(dd,-day(@BeginTime)+1,@BeginTime)
--本月最后一天:
SELECT dateadd(ms,-3,DATEADD(mm, DATEDIFF(m,0,@BeginTime)+1, 0))
--定义变量
declare @BeginTime datetime = '2018-02-05'
--获得传入月份第一天
select dateadd(dd,-day(@BeginTime)+1,@BeginTime)
--本月最后一天:
SELECT dateadd(ms,-3,DATEADD(mm, DATEDIFF(m,0,@BeginTime)+1, 0))