php - MySQL年周函数空间

Question

我在选择查询中使用函数 yearweek。

我的问题 = 日期 = 2017-02-13 || yearweek = 201707。如何在 2017 07

之间获取空格

Answer 1

您可以使用 DATE_FORMAT:

CREATE TABLE tu(datum DATE);
INSERT INTO tu(datum) VALUES ('2017-02-13');

SELECT  datum, DATE_FORMAT(datum, '%X %V'), YEARWEEK(datum)
FROM tu;

输出:

13.02.2017 00:00:00       2017 07          201707

Rextester Demo

%X Year for the week where Sunday is the first day of the week. Used with %V

%x Year for the week where Monday is the first day of the week. Used with %V