skip to Main Content

MySQL datediff function not available in SQLite used for unit tests – Laravel

I have used the following Raw query in my Laravel project. $statisticsInRangeDate = $myModel->selectRaw( "floor(datediff(created_at, '{$dateInfo['currentRangeDate']}')". " / {$dateInfo['daysRange']}) * {$dateInfo['daysRange']} AS diff_days_range, count(*) as total_clicks, ". 'min(created_at) ,max(created_at)' ) ->groupByRaw('diff_days_range') ->orderByRaw('diff_days_range DESC') ->get(); The raw query is: select floor(datediff(created_at,…

VIEW QUESTION
Back To Top
Search