如何订购此MySQL日期？

Question

我在按日期排序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

但似乎不起作用..。

我怎么才能让它按那个日期和时间排序呢？

Answer 1

假设您的DateAndHour列是一个字符串，那么您可能需要进行适当的转换

  SELECT PlayerSteamID
    , BanLength
    , BanReason
    , AdminName
    , AdminSteamID
    , PlayerName
    , MapName
    , DateAndHour 
  FROM BansList
  ORDER BY str_to_date(DateAndHour, '%T - %d/%m/%Y')  DESC