我在按日期排序mysql結果時遇到問題。日期格式如下：15:24:57-21/04/2019（24小時制）我已經試過了：SELECT PlayerSteamID, BanLength, BanReason, AdminName, AdminSteamID, PlayerName, MapName, DateAndHour FROM BansList ORDER BY DateAndHour DESC和這個SELECT PlayerSteamID, BanLength, BanReason, AdminName, AdminSteamID, PlayerName, MapName, DateAndHour FROM BansList ORDER BY UNIX_TIMESTAMP(STR_TO_DATE(DateAndHour, '%h:%i:%s - %d/%m/%Y')) DESC但是似乎不起作用...我該如何做才能按日期和時間排序？
1 回答
心有法竹
TA貢獻1866條經驗 獲得超5個贊
假設您的DateAndHour列是一個字符串，可能是您需要適當的轉換
SELECT PlayerSteamID
, BanLength
, BanReason
, AdminName
, AdminSteamID
, PlayerName
, MapName
, DateAndHour
FROM BansList
ORDER BY str_to_date(DateAndHour, '%T - %d/%m/%Y') DESC
- 1 回答
- 0 關注
- 169 瀏覽
添加回答
舉報
0/150
提交
取消