SQL Server 2005 数据库中的日期数据排序 2014/10/23 15193 SELECT email_address AS EmailAddress, CONVERT(nvarchar, lastcontact, 101) AS Last_Contact FROM Contact ORDER BY lastcontact DESC