create function datevalid(@dt datetime)
returns varchar(6)
as
begin
declare @imonth int
declare @nmonth varchar(2)
set @dt=dateadd(month,1,@dt)
set @imonth=convert(int,datepart(month,@dt))
if(@imonth<10)
set @nmonth='0'+convert(varchar(2),@imonth)
else
set @nmonth=convert(varchar(2),@imonth)
return(convert(varchar(4),datepart(year,@dt))+@nmonth)
end
GO
returns varchar(6)
as
begin
declare @imonth int
declare @nmonth varchar(2)
set @dt=dateadd(month,1,@dt)
set @imonth=convert(int,datepart(month,@dt))
if(@imonth<10)
set @nmonth='0'+convert(varchar(2),@imonth)
else
set @nmonth=convert(varchar(2),@imonth)
return(convert(varchar(4),datepart(year,@dt))+@nmonth)
end
GO
returns varchar(6)
as
begin
declare @imonth int
declare @nmonth varchar(2)
set @imonth=convert(int,datepart(month,@dt))
if(@imonth<10)
set @nmonth='0'+convert(varchar(2),@imonth)
else
set @nmonth=convert(varchar(2),@imonth)
return(convert(varchar(4),datepart(year,@dt))+@nmonth)
end
GO
转成‘yyyy-mm’