如何从上个月减去当月 [英] how to subtract current month from previous month
问题描述
嗨所有
i想要减去当月最后一个月的当前月份。
请给我一些想法和解决方案。
i我在DATEADD(月,-2,getdate())和DATEADD之间使用
(月,-1,getdate()
但它返回前两个月的差异,当我在DATEADD(月,-1,getdate())和DATEADD(月,-1,getdate())之间使用时
它显示没有数据
所以请帮助我。
亲爱的杰克逊请使用
< pre lang =c#> 介于DATEADD(月,-1,getdate())和getdate()
通过这个...
上个月的上个月
SELECT DATEADD(s,-1,DATEADD(mm,DATEDIFF(m, 0 ,GETDATE()), 0 ))
当前月份的最后日期
SELECT DATEADD(S,-1,DATEADD(mm,DATEDIFF(m) , 0 ,GETDATE())+ 1, 0 ))
当月和上个月的差异
选择 DATEDIFF(M,DATEADD(s,-1,DATEADD(mm,DATEDIFF(m, 0 ,GETDATE() ), 0 )),DATEADD(S,-1,DATEADD(mm,DATEDIFF(m, 0 ,GETDATE())+ 1, 0 )))
或试试这个
选择 MONTH(DATEADD(S,-1,DATEADD(mm,DATEDIFF(m, 0 ,GETDATE())+ 1, 0 ))) - 月(DATEADD(s,-1) ,DATEADD(mm,DATEDIFF(m, 0 ,GETDATE()), 0 )))
或者使用
选择 datediff(月,DATEADD(月,-1,getdate( )),GETDATE())
hi all
i want to subtract current month from previous month on the last date of current month.
please give me ideas and solutions.
i am using
between DATEADD(month,-2,getdate()) and DATEADD(month,-1,getdate()
but it returns difference of previous two months and when i use between DATEADD(month,-1,getdate()) and DATEADD(month,-1,getdate())
it shows no data
so please help me.
dear jackson please use
between DATEADD(month,-1,getdate()) and getdate()
Hi, Go through this...
Previous months last date
SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE()),0))
Current months last date
SELECT DATEADD(S,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+1,0))
Difference for current month and previous month in month
Select DATEDIFF(M,DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE()),0)),DATEADD(S,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+1,0)))
Or try this
Select MONTH(DATEADD(S,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+1,0)))- MONTH(DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE()),0)))
Or use
Select datediff(Month,DATEADD(month,-1,getdate()) ,GETDATE() )
这篇关于如何从上个月减去当月的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!