SQL Date Utility

分享一下我老师大神的人工智能教程！零基础，通俗易懂！http://blog.youkuaiyun.com/jiangjunshow

也欢迎大家转载本篇文章。分享知识，造福人民，实现我们中华民族伟大复兴！

               

DECLARE @currentDate DATETIMESELECT @currentDate = GETDATE()SELECTCONVERT(nvarchar(20), GETDATE(), 101) AS Today,MONTH(CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(@currentDate)),@currentDate),101)) AS PreviousMonth,MONTH(GETDATE()) AS CurrentMonth,CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(@currentDate)+DAY(CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(@currentDate)),@currentDate),101))-1),@currentDate),101) as FirstDayOfPreviousMonth,CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(@currentDate)),@currentDate),101) as LastDayOfPreviousMonth,CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(@currentDate)-1),@currentDate),101) AS FirstDayOfCurrentMonth,CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(DATEADD(mm,1,@currentDate))),DATEADD(mm,1,@currentDate)),101) as LastDayOfCurrentMonthGO

           

给我老师的人工智能教程打call！http://blog.youkuaiyun.com/jiangjunshow