declare @dt datetime
set @dt = '2002-1-1 12:23:22'
set @dt = convert(varchar,@dt,101)
select @dt
ordeclare @dt datetime
set @dt = '2002-1-1 12:23:22'
select convert(datetime,convert(varchar,@dt,101))
set @dt = '2002-1-1 12:23:22'
set @dt = convert(varchar,@dt,101)
select @dt
ordeclare @dt datetime
set @dt = '2002-1-1 12:23:22'
select convert(datetime,convert(varchar,@dt,101))
select convert(varchar(8),getdate(),112)
2003-02-18