declare @date datetime
select @date=getdate()
declare @char char(10)
select @char=year(@date)*10000+month(@date)*100+day(@date)
print @char
select @date=getdate()
declare @char char(10)
select @char=year(@date)*10000+month(@date)*100+day(@date)
print @char
select convert(char(10),getdate(),112)