sql合并字段

create table Test
(
	id int primary key identity(1,1),
	[FillYear] int,
	[FillMonth] int,
	[FillDay] int
)
select * from Test;

insert into Test(FillYear,FillMonth,FillDay) values(2014,9,12);
insert into Test(FillYear,FillMonth,FillDay) values(2013,9,14);
insert into Test(FillYear,FillMonth,FillDay) values(2015,10,14);


select *,CAST(CAST(FillYear as nvarchar(50))+'-'+CAST(FillMonth as nvarchar(50))+'-'+CAST(FillDay as nvarchar(50)) as datetime) as FillDate from Test;