如何指定mySQL的MONTH()函数返回'08‘,而不是此查询中的8?
我想让它按日期工作。当前正在获取日期的结果,如
2006-9
2007-1
2007-10
2007-11
当前查询:
SELECT COUNT(*), CONCAT(YEAR(`datetime_added`), '-', MONTH(`datetime_added`)) as date FROM `person` WHERE (email = '' OR email IS NULL)
GROUP BY date
ORDER BY date ASC
发布于 2011-08-13 01:15:24
您可以像这样使用填充
SELECT
COUNT(*),
CONCAT(YEAR(`datetime_added`), '-', LPAD(MONTH(`datetime_added`), 2, '0')) as date
FROM `person`
WHERE (email = '' OR email IS NULL)
GROUP BY date
ORDER BY date ASC
发布于 2011-08-13 01:15:37
DATE_FORMAT(`datetime_added`,'%Y - %m')
发布于 2011-08-13 01:15:13
MONTH()返回一个整数,所以当然没有前导零。您需要将其转换为字符串,左键填充“0”,然后取最后2个字符。
https://stackoverflow.com/questions/7043794
复制相似问题