--try
declare @t datetime
set @t='2005-07-21 16:57:57.000'
select stuff(convert(varchar(10),@t,120),1,5,'')
--结果
07-21(所影响的行数为 1 行)
declare @t datetime
set @t='2005-07-21 16:57:57.000'
select stuff(convert(varchar(10),@t,120),1,5,'')
--结果
07-21(所影响的行数为 1 行)
year()
--这里用不到year()吧,可以用month(),day()declare @t datetime
set @t='2005-07-21 16:57:57.000'
select right('00' + convert(varchar(2),month(@t)),2) + '-' + right('00' + convert(varchar(2),day(@t)),2)
/*
---------
07-21(1 row(s) affected)
*/
set @a='2005-07-21 16:57:57.000'
select right(convert(char(10),@a,120),5)--结果
07-21