求php大佬，tp6里DATE_FORMAT要怎么写SELECT DATE_FORMAT( create_tim

Question

SELECT DATE_FORMAT( create_time, "%Y-%m-%d %H" ), SUM(jin),SUM(chu) FROM sysbui GROUP BY DATE_FORMAT( create_time, "%Y-%m-%d %H" ) 

上面是sql 转换成tp6的要怎么写，老是报错
试过

    $Db = Db::table('sysbui')
        ->field('date_format(create_time, "%Y-%m-%d %H"), sum(jin) AS jin_max, sum(chu) AS chu_max')
        ->group('date_format(create_time, "%Y-%m-%d %H")')
        ->select();

试过

    $Db = Db::table('sysbui')
        ->field(date_format(create_time, "%Y-%m-%d %H"), sum(jin) AS jin_max, sum(chu) AS chu_max')
        ->group(date_format(create_time, "%Y-%m-%d %H"))
        ->select();

Answer 1

参考文档 使用 SQL 函数