--try
select convert(varchar(10),'2005-02-02 22:21:56',120)
--Result
----------
2005-02-02(所影响的行数为 1 行)
select convert(varchar(10),'2005-02-02 22:21:56',120)
--Result
----------
2005-02-02(所影响的行数为 1 行)
set @dt='2005-02-02 22:21:56'
select convert(varchar(10),@dt,120)
如果是字符串用 select left('2005-02-02 22:21:56 ',10) 或 select substring('2005-02-02 22:21:56',1,10)
SELECT TOP 1 UserName,convert(varchar(10),RegisterDate,120) FROM userMember