addtime是時間字段

shop是數據表

subtotal要統計的字段

select * from shop where DATE_FORMAT(addtime,'%Y-%m-%d')=to_days(now()) group by addtime;

$daybegin=strtotime(date('Y-m-d'));

$dayend=$daybegin+86400;

$sql = "select sum(subtotal) as pay from shop where addtime < $dayend and addtime > $daybegin group by FROM_UNIXTIME(addtime,'%y-%m-%d')";

print_r($sql);

打印如下sql語句；

select sum(subtotal) from shop where addtime < 1477238400 and addtime > 1477152000 group by FROM_UNIXTIME(addtime,'%y-%m-%d')

$daybegin=strtotime(date('Y-m-d'));

$dayend=$daybegin+86400;

//查詢當天的數據

$sql="select * from my_money where?time < $dayend and time > $daybegin";

//統計當天支出總額

$sql_out="select sum(cash) as cashout?from my_money where time < $dayend and time > $daybegin and type=1";

//統計當天收入總額

$sql_in="select sum(cash) as?cashin from my_money where time < $dayend and time > $daybegin and type=2";

總結

以上是生活随笔為你收集整理的mysql计算订单总金额_mysql统计当天消费总额的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。