Antonio1512 Asked: 2022-10-17 11:05:15 +0800 CST 2022-10-17 11:05:15 +0800 CST 2022-10-17 11:05:15 +0800 CST How to add current day sale totals in mysql? 772 I would like to get the total sales of the current day in my mysql query Those are the columns of my table mysql 1 Answers Voted Best Answer Several Tool 2022-10-17T11:10:20+08:002022-10-17T11:10:20+08:00 It would be something like this: SELECT SUM(ventas.total) FROM ventas WHERE DAY(ventas.fecha) = DAY(CURRENT_DATE()); See if that's what you wanted
It would be something like this:
See if that's what you wanted