php - 总和 :two different time query

Question

我用字段 'buy_datetime' 和 sell_datetime 设置了我的 MySQL 数据库。我想以小时为单位获得不同日期时间的总时间结果。格式:'1000-01-01 00:00:00'.

例如，

1. buy_datetime - sell_datetime = 1result
2. buy_datetime - sell_datetime = 2result

输出总小时数 = 1resul + 2result。

    public function firstHourHoldingTime(){

        $count_firsthour_holding_time =  DB::table('finaltrade')
            ->select(DB::raw('finaltrade.*'))
            ->sum(TIMEDIFF(Hour,"buy_datetime", "sell_datetime"))
            ->get();
    }

Answer 1

您需要原始表达式来总结列之间的每小时差异

public function firstHourHoldingTime(){

    $count_firsthour_holding_time =  DB::table('finaltrade')
        ->select(DB::raw('SUM(TIMESTAMPDIFF(HOUR,buy_datetime, sell_datetime)) as total'))
        ->get();
}