http://topic.csdn.net/u/20070321/09/f1fb9632-effc-42c3-8fc2-00a4ae125cc9.html
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
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/93029/viewspace-1026276/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/93029/viewspace-1026276/