Convert(varchar(10), datetimefield, 111)decimal
Fixed precision and scale numeric data from -10^38 +1 through 10^38 –1. numeric
Functionally equivalent to decimal.
Fixed precision and scale numeric data from -10^38 +1 through 10^38 –1. numeric
Functionally equivalent to decimal.
set @temp1 = '2002-02-22 00:00:00'
select convert(varchar(10),@temp1,120)