PHP MySQL汇总列IF行具有正确的时间戳(PHP MySQL Sum a column IF row have the right timestamp)
我有1个表有3列:id,金额,日期我想计算金额只有今天的日期是今天的PHP与MySQL,我试过各种事情,但没有一个工作,为计算今天的日期,我使用$ date =日期('m / d / y');
i have 1 table with 3 column: id, amount, date i want to calculate the amount only if the date is today in PHP with MySQL, i tried with various thing but none of them worked, for calculate the today date i use $date = date('m/d/y');
最满意答案
SELECT SUM (CASE WHEN DATE(`date`) = DATE(NOW()) THEN amount ELSE 0 END) FROM my_table编辑:
正如@ user3760540的评论中所建议的,使用CURDATE()可能更优雅:
SELECT SUM (CASE WHEN DATE(`date`) = CURDATE()) THEN amount ELSE 0 END) FROM my_table SELECT SUM (CASE WHEN DATE(`date`) = DATE(NOW()) THEN amount ELSE 0 END) FROM my_tableEDIT:
As suggested in the comments by @user3760540, using CURDATE() could be more elegant:
SELECT SUM (CASE WHEN DATE(`date`) = CURDATE()) THEN amount ELSE 0 END) FROM my_table更多推荐
发布评论