How to split the date format into month with year?

Question

create table estr ( custo int product varchar(20) val int billed_date datetime ) insert into estr(custoproductbilled_datevalue) values('10''Milk''2013-04-11''2000') insert into estr(custoproductbilled_datevalue) values('10''Milk''2013-04-21''500') insert into estr(custoproductbilled_datevalue) values('10''Milk''2013-05-05''100') insert into estr(custoproductbilled_datevalue) values('10''Milk''2013-05-11''2000') insert into estr(custoproductbilled_datevalue) values('10''fruits''2013-05-11''500') insert into estr(custoproductbilled_datevalue) values('30''fruits''2013-04-11''2000') insert into estr(custoproductbilled_datevalue) values('30''fruits''2013-05-11''1000') from here i wanna extract the month with year for counting purpose how ll do ? guide me?

Khan Abrar Ahmed · Answer

Hi DECLARE @estr AS TABLE ( custo int product varchar(20) billed_date DATETIME VALUE VARCHAR(6) ) insert into @estr(custoproductbilled_datevalue) values('10''Milk''2013-04-11''2000') insert into @estr(custoproductbilled_datevalue) values('10''Milk''2013-04-21''500') insert into @estr(custoproductbilled_datevalue) values('10''Milk''2013-05-05''100') insert into @estr(custoproductbilled_datevalue) values('10''Milk''2013-05-11''2000') insert into @estr(custoproductbilled_datevalue) values('10''fruits''2013-05-11''500') insert into @estr(custoproductbilled_datevalue) values('30''fruits''2013-04-11''2000') insert into @estr(custoproductbilled_datevalue) values('30''fruits''2013-05-11''1000') SELECT *MONTH(billed_date) AS MonthYEAR(billed_date) AS Year FROM @estr please mark as answer if it works.

Sandeep Singh Shekhawat · Answer

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