SQL查询上月和本月两个月的语句

        ,dateadd(dd,-day(dateadd(month,-1,getdate()))+1,dateadd(month,-1,getdate()))     /*上个月一号*/  
        , dateadd(dd,-day(getdate()),getdate())  /* 上月月底 */                                               
        , dateadd(dd,-day(getdate())+1,getdate())        /* 本月一号 */    

       ,dateadd(dd,-day(dateadd(month,1,getdate())),dateadd(month,1,getdate()))            /* 本月底 */ 

原文地址:https://www.cnblogs.com/xubin-747/p/5784460.html