Sql获取当月月初和月末的时间
标签：
Sql获取当月月初和月末的时间
@CurrentTime DATETIME
DECLARE @Start DATETIME
DECLARE @End DATETIME
SET @CurrentTime = GETDATE()
SET @Start = DATEADD(ms, -1, DATEADD(mm, DATEDIFF(m, 0, @CurrentTime), 0))
SET @End = DATEADD(ms, -3, DATEADD(mm, DATEDIFF(m, 0, @CurrentTime) + 1, 0))
PRINT @CurrentTime
PRINT @Start
PRINT @End