上個月26到這個月25號 SQL

select dateadd(day,26,dateadd(month,-1,DATEADD(day,0-day(getdate()),getdate()))) as hehe

select dateadd(day,25,DATEADD(day,0-day(getdate()),getdate())) as 本月25號

select 上個月26號 = convert(varchar(8),DATEADD(m, -1, getdate()),21)+ '26 ' , 本月25號=convert(varchar(8),getdate(),21)+ '25 '
---日期型
select 上個月26號 = convert(datetime,convert(varchar(8),DATEADD(m, -1, getdate()),21)+ '26 ') , 本月25號=convert(datetime,convert(varchar(8),getdate(),21)+ '25 ')

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

declare @fkfs varchar(25), @yjr varchar(8), @company varchar(20), @rq datetime
set @fkfs ='結30天'
set @rq = getdate()
--set @fkfs ='Net 30 days'
-- 結30天 結60天 結90天
-- select @fkfs=fkfs from gys where id =@company
-- select @fkfs=fkfs from kh where id =@company
-- select @fkfs as haha
-- convert(varchar(8),DATEADD(m, -1, getdate()),21)+ '26 '
-- convert(datetime,convert(varchar(8),DATEADD(m, -1, getdate()),21)+ '26 ')
if (@fkfs = 'Net 30 days' )
begin
select @rq = dateadd(day,30,@rq)
select @rq as haha
-- select * from company
end
else if (@fkfs ='結30天')
begin
select dateadd(day,-1,convert(datetime,convert(varchar(8),DATEADD(m, 2, getdate()),21)+ '1 '))
--select * from iems_file
end
else if (@fkfs ='結60天')
begin
select dateadd(day,-1,convert(datetime,convert(varchar(8),DATEADD(m, 3, getdate()),21)+ '1 '))
-- select * from iems_file
end
else if (@fkfs ='結90天')
begin
select dateadd(day,-1,convert(datetime,convert(varchar(8),DATEADD(m, 4, getdate()),21)+ '1 '))
-- select * from iems_file
end

[@more@]