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

 

Sql获取当月月初和月末的时间

标签：

查看更多关于Sql获取当月月初和月末的时间的详细内容...