![]() |
#2
StrayInSky2008-01-14 14:13
|
if (right(rtrim(@strCloseDate),2) = '00' )
begin
set @strCloseDate = (left(@strCloseDate,4) - 1)
set @strCloseDate = @strCloseDate + '12'
end
其中strclosedate为日期类型
谢谢大家!