create function [dbo].[ToNY]
(
@BeginDate datetime
)
returns nvarchar(100)
as
begin
declare @MyYear int,@MyMonth int,@MyDay int,@MyDate datetime,@MyDateName nvarchar(100)
set @MyYear=datepart(year,@BeginDate)
set @MyMonth=datepart(month,@BeginDate)
set @MyDay=datepart(day,@BeginDate)
if LEN(@MyMonth)=1
set @MyDateName=convert(varchar(4),@MyYear)+N'年0'+convert(varchar(2),@MyMonth)+N'月'
else
set @MyDateName=convert(varchar(4),@MyYear)+N'年'+convert(varchar(2),@MyMonth)+N'月'
--if LEN(@MyDay)=1
--set @MyDateName=@MyDateName+'0'+convert(varchar(2),@MyDay)+N'日'
--else
--set @MyDateName=@MyDateName+convert(varchar(2),@MyDay)+N'日'
return @MyDateName
end