时间戳

首页 > 解决方案 > 将 DATE() 与 SELECT 一起使用

mysql - 将 DATE() 与 SELECT 一起使用

问题描述

查询我的 MySQL 数据库时，我使用该行

SELECT `playlistDate` from `tracks` GROUP BY `playlistDate`

JSON 化的结果语句是这样的

[{"playlistDate":"2020-09-14T05:00:00.000Z"},{"playlistDate":"2020-09-21T05:00:00.000Z"},
{"playlistDate":"2020-09-28T05:00:00.000Z"},{"playlistDate":"2020-10-05T05:00:00.000Z"},
{"playlistDate":"2020-10-12T05:00:00.000Z"},{"playlistDate":"2020-10-19T05:00:00.000Z"},
{"playlistDate":"2020-10-26T05:00:00.000Z"},{"playlistDate":"2020-11-02T06:00:00.000Z"}

我希望它看起来像这样，没有时间戳

[{"playlistDate":"2020-09-14"},{"playlistDate":"2020-09-21"},
{"playlistDate":"2020-09-28"},{"playlistDate":"2020-10-05"},
{"playlistDate":"2020-10-12"},{"playlistDate":"2020-10-19"},
{"playlistDate":"2020-10-26"},{"playlistDate":"2020-11-02"}

我尝试将查询更改为其中任何一个都没有运气

SELECT DATE(`playlistDate` from `tracks` GROUP BY `playlistDate`)

SELECT DATE(`playlistDate`) from `tracks` GROUP BY `playlistDate`

如何使用该DATE()功能来获得我期望的结果？

标签： mysql

解决方案

丑陋的方法是使用 substr(playlistDate, 1, 10).

你也可以使用DATE_FORMAT(playlistDate,'%y-%m-%d')

推荐阅读