MySQL日期格式DD/MM/YYYY选择查询? [英] MySQL date format DD/MM/YYYY select query?

问题描述

我对如何按日期格式排序有些困惑.

I'm a bit confused on how to order by date formats.

对于格式YYYY-MM-DD，您可以执行以下操作:...ORDER BY date DESC...

For the format YYYY-MM-DD you would do this: ...ORDER BY date DESC...

您如何按DD/MM/YYYY订购?

这不起作用:

SELECT * FROM $table ORDER BY DATE_FORMAT(Date, '%Y%m%d') DESC LIMIT 14

推荐答案

您可以使用

You can use STR_TO_DATE() to convert your strings to MySQL date values and ORDER BY the result:

ORDER BY STR_TO_DATE(datestring, '%d/%m/%Y')

但是，明智的做法是将列转换为DATE数据类型，而不是使用字符串.

However, you would be wise to convert the column to the DATE data type instead of using strings.

这篇关于MySQL日期格式DD/MM/YYYY选择查询?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！