order by datetime 只判斷年月日 不看時分秒

SELECT *FROM Attendance WHERE Swt BETWEEN '2014-08-02 00:00:00' AND '2014-08-02 23:59:59' order by convert(varchar(10),Swt,112) ASC, Mid ASC


Swt是個datetime的資料 有年月日時分秒

ASC 遞增排序

DESC遞減排序