'in.attendance_time as in_time'、'out.attendance_time as out_time' 的輸出，
$absen = DB::table('attendance as in')
->where('in.in_out', 'in')
->where('in.company_id', \Session::get('selected_company'))
->whereDate('in.created', Carbon::today())
->leftJoin('attendance as out', function ($join) {
$join->on('in.employee_id', 'out.employee_id')
->where('out.in_out', 'out')
->where('out.company_id', \Session::get('selected_company'))
->whereDate('out.created', Carbon::today());
})
->join('employee', 'employee.id', 'in.employee_id')
->join('location_library', 'location_library.id', 'in.attendance_location_id')
->join('company as cp', 'cp.id', 'in.company_id')
->join('employee_in_app as e_app', 'e_app.employee_id', 'in.employee_id')
->join('employee_in_company', 'in.employee_id', 'employee_in_company.employee_id')
->select('employee.name', 'cp.alias', 'in.employee_id','location_library.location_name', 'in.attendance_time as in_time', 'out.attendance_time as out_time', 'e_app.note')
->orderBy('in.attendance_time', 'DESC')
->get();
我想只檢索小時、分鐘和秒，而選擇中沒有日期、月份和年份，如何解決這個問題？顯示日期的資料是 'in.attendance_time as in_time', 'out.attendance_time as out_time',
uj5u.com熱心網友回復：
使用此DB::raw查詢格式化日期
->select('employee.name', 'cp.alias', 'in.employee_id','location_library.location_name', DB::raw('DATE_FORMAT(in.attendance_time, "%H-%i-%s") as in_time'), DB::raw('DATE_FORMAT(out.attendance_time, "%H-%i-%s") as out_time'), 'e_app.note')
轉載請註明出處，本文鏈接：https://www.uj5u.com/yidong/430648.html