yyyy-mm-dd hh:mm:ss 转换 mysql date,在MySQL中仅从日期时间（YYYY-MM-DD HH：MM：SS）中按日期选择不同的日期...

Executing this command brings me the following (all the dates from all columns, so it essentially did the same thing as SELECT date without distinct):

SELECT DISTINCT date FROM daily ORDER BY date DESC

2013-02-12 16:40:52

2013-02-06 11:48:49

2013-02-06 11:36:41

2013-02-06 11:35:59

2013-02-04 19:38:12

2013-02-04 18:12:30

2013-02-04 09:58:41

2013-02-04 09:43:01

2013-02-04 09:35:51

2013-02-04 09:30:22

2013-02-04 09:24:57

2013-02-04 09:21:09

2013-02-04 08:50:13

What I need:

2013-02-12

2013-02-06

2013-02-04

Is there any way to alter my date table and convert it to YYYY-MM-DD instead?

If not, is there a way to select distinct dates based only on the day?

解决方案mysql> select DATE_FORMAT(Current_Timestamp, '%c %d %Y') from dual;

+--------------------------------------------+

| DATE_FORMAT(Current_Timestamp, '%c %d %Y') |

+--------------------------------------------+

| 2 12 2013 |

+--------------------------------------------+

1 row in set (0.01 sec)

mysql>

of course you would be using your 'daily' table.

mysql> select DATE_FORMAT(Date, '%c %d %Y') from daily;

or maybe you want

mysql> select * from daily group by DATE_FORMAT(Date, '%c %d %Y');