Sql Server 日期格式化时间:2022-12-13 08:33:55select CONVERT(date,myDtae,23),ID from myFirstTable; http://www.cnblogs.com/hantianwei/archive/2009/12/03/1616148.html