php - Laravel Eloquent 查询顺序按时间字段的 DESC 和 AM/PM

Question

我这样尝试 "TimeModel::where('deleted', 0)->orderBy(DB::raw(STR_TO_DATE('appointment_time','%l:%i %p')))->get( );"但没有用。

请帮帮我。

Answer 1

首先使用DB facade，

use Illuminate\Support\Facades\DB;

然后，

addSelect(DB::raw('TIME_FORMAT(appointment_time,"%H:%i") as apt_time'))->orderBy('apt_time','DESC');