datetime

declare @a  datetime
set @a='2008-01-01 11:11:11'
select @a
select CONVERT(varchar(10),@a,102)