How to split the date format into month with year?

Hi,

DECLARE @estr AS TABLE

(
custo int,
product varchar(20),
billed_date DATETIME,
VALUE VARCHAR(6)
)



insert into @estr(custo,product,billed_date,value) values('10','Milk','2013-04-11','2000')

insert into @estr(custo,product,billed_date,value) values('10','Milk','2013-04-21','500')

insert into @estr(custo,product,billed_date,value) values('10','Milk','2013-05-05','100')

insert into @estr(custo,product,billed_date,value) values('10','Milk','2013-05-11','2000')

insert into @estr(custo,product,billed_date,value) values('10','fruits','2013-05-11','500')

insert into @estr(custo,product,billed_date,value) values('30','fruits','2013-04-11','2000')


insert into @estr(custo,product,billed_date,value) values('30','fruits','2013-05-11','1000')

SELECT *,MONTH(billed_date) AS Month,YEAR(billed_date) AS Year FROM @estr

please mark as answer if it works.

declare @month nvarchar(2)=  DATEPART(MM,'2013-05-11')

declare @year nvarchar(4) = DATEPART(YYYY,'2013-05-11')

declare @date nvarchar(7) = @month+'/'+ @year

Print @date