Sql Server 日期格式化

select CONVERT(date,myDtae,23),ID from myFirstTable;

http://www.cnblogs.com/hantianwei/archive/2009/12/03/1616148.html