select CONVERT(date,myDtae,23),ID from myFirstTable;
http://www.cnblogs.com/hantianwei/archive/2009/12/03/1616148.html
2022-10-20 18:40:55
select CONVERT(date,myDtae,23),ID from myFirstTable;
http://www.cnblogs.com/hantianwei/archive/2009/12/03/1616148.html