PHP MySQL汇总列IF行具有正确的时间戳(PHP MySQL Sum a column IF row have the right timestamp)

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_table

EDIT:

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