用convert()函数转换下select convert(nvarchar(10),colname ,120) from tb
select convert(nvarchar(10),某列,120) from 某表 where 条件
select convert(nvarchar(10),某列,120) from 某表 where 条件
select convert(varchar(9),'2007-6-7 10:10:10',120) result/* result -------------- 2007-6-7 */select convert(varchar(9),cast('2007-6-7 10:10:10' as datetime),120) result /* result -------------- 2007-06-07*/
select convert(varchar(10),cast('2007-6-7 10:10:10'as datetime),120) result/* result -------------- 2007-06-07*/
select convert(nvarchar(10),某列,120) from 某表 where 条件
result
--------------
2007-6-7
*/select convert(varchar(9),cast('2007-6-7 10:10:10' as datetime),120) result
/*
result
--------------
2007-06-07*/
select convert(varchar(10),cast('2007-6-7 10:10:10'as datetime),120) result/*
result
--------------
2007-06-07*/