2024年6月12日发(作者：)

sql计算天数

SELECT dateadd(ms,-1,DATEADD(mm,

DATEDIFF(m,0,getdate()), 0)) as mouthfirstdate,dateadd(ms,-3,DATEADD(mm,

DATEDIFF(m,0,getdate())+1, 0)) as mouthlastdate

===============================最后一天

=========================================

本月【数据所在服务器】最后一天：

SELECT dateadd(ms,-3,DATEADD(mm, DATEDIFF(m,0,getdate())+1, 0)) as

mouthlastdate

下月【数据所在服务器】最后一天：

SELECT dateadd(ms,-3,DATEADD(mm, DATEDIFF(m,0,getdate())+2, 0)) as

mouthlastdate

下下月【数据所在服务器】最后一天：

SELECT dateadd(ms,-3,DATEADD(mm, DATEDIFF(m,0,getdate())+3, 0)) as

mouthlastdate

下下下月【数据所在服务器】最后一天：

SELECT dateadd(ms,-3,DATEADD(mm, DATEDIFF(m,0,getdate())+4, 0)) as

mouthlastdate

下下下月【数据所在服务器】最后一天：

SELECT dateadd(ms,-3,DATEADD(mm, DATEDIFF(m,0,getdate())+5, 0))

mouthlastdate

下下下下月【数据所在服务器】最后一天：

SELECT dateadd(ms,-3,DATEADD(mm, DATEDIFF(m,0,getdate())+6, 0))

mouthlastdate

===============================第一

===========================================

本月第一天

SELECT dateadd(ms,-1,DATEADD(mm, DATEDIFF(m,0,getdate()), 0))

mouthlastdate

as

as

天

as