select CONVERT(date,myDtae,23),ID from myFirstTable;
http://www.cnblogs.com/hantianwei/archive/2009/12/03/1616148.html
转载于:https://www.cnblogs.com/jieran-zero/p/6290753.html