I'm a bit confused on how to order by date formats.
(我对如何按日期格式排序有些困惑。)
For the format YYYY-MM-DD
you would do this: ...ORDER BY date DESC...
(对于YYYY-MM-DD
格式,您可以执行以下操作: ...ORDER BY date DESC...
)
How would you order by DD/MM/YYYY
?
(您如何按DD/MM/YYYY
订购?)
This isn't working:
(这不起作用:)
SELECT * FROM $table ORDER BY DATE_FORMAT(Date, '%Y%m%d') DESC LIMIT 14
ask by Karl Morrison translate from so