用函数呀,比如:
select convert(char(4),year(time)) + '-' + convert(varchar(2),month(time)) + '-' + convert(varchar(2),day(time))
select convert(char(4),year(time)) + '-' + convert(varchar(2),month(time)) + '-' + convert(varchar(2),day(time))
Y: select convert(char(10), time, 121)N: right