试图与mysql和sqlite获得不同的约会

Question

For my application, I'm using Laravel and trying to figure out how I can adjust this query because in development I"m using MySQL but for testing, I'm using SQLite. The problem is that I can't use DATEDIFF for SQLite. Does anyone have a suggestion on what I should do to retrieve the champion with the longest title length?

return Champion::with('team')
        ->select(\DB::raw('DATEDIFF(IFNULL(DATE(champions.lost_on), '. Carbon::now()->toDateString().'), DATE(champions.won_on)) as length, team_id'))
        ->where('title_id', $title->id)
        ->orderBy('length', 'desc')
        ->groupBy('length', 'team_id')
        ->first();

Answer 1

In SQLite you can use

julianday('now') - julianday(DateCreated)