Postgresql to Laravel eloquent

Question

请有人教我如何在laravel DB:raw()中使用COALESCE和TO_CHAR

SELECT MAX(COALESCE(SUBSTR("COLUMN_CODE",8),'0')) AS MAX
FROM public."TABLE_ITEM"
WHERE COALESCE(TO_CHAR("START_DATE",'YYYYMM'),TO_CHAR("RECEIVED_DATE",'YYYYMM')) = '202104'

已尝试使用DB:raw，但仍出现错误

selectRaw("MAX(COALESCE(SUBSTR(COLUMN_CODE,8),0)) AS MAX")
->whereRaw("COALESCE(TO_CHAR("START_DATE",'YYYYMM'),TO_CHAR("RECEIVED_DATE",'YYYYMM')) = '202104'")

Answer 1

我认为你没有正确使用引号。下面是如何在whereRaw()方法中对SQL函数使用引号的一些示例：

->whereRaw("tv_technicals.created_at BETWEEN DATE_SUB(candidates.pierce_time, INTERVAL 1 HOUR)
                            AND DATE_ADD(candidates.pierce_time, INTERVAL 1 HOUR)");