我正在嘗試創建一個查詢來顯示所有驅動程式的資訊，并且只在 created_at 列中獲取“年份”。誰能幫我？提前致謝
這是回應查詢
"user_id": 45,
"driver_fname": "Sample",
"driver_mname": "Sample",
"driver_lname": "Sample",
"driver_birthday": "2000-07-28",
"years_driving_experience": null,
"years_driving_experience_quicktrans": null,
"start_year_of_exp_in_driving": null,
"start_year_of_exp_in_driving_in_quicktrans": null,
"educational_attainment": null,
"health_status": null,
"drug_test": null,
"marital_status": null,
"Salary_range": null,
"license_registration": null,
"license_expiration": null,
"license_condition": null,
"medication_maintenance": null,
"training": null,
"driver_height": null,
"driver_weight": null,
"weight_status": null,
"emergency_contact_number": null,
"home_address_street_number": null,
"home_address_street": null,
"home_address_brgy": null,
"home_address_city": null,
"work_hours_range": null,
"work_shift": null,
"sleep_hours_range": null,
"smoker": null,
"created_at": "2021-11-23 03:50:33"
created_at 列應該在 Year，例如 created_at:"2021"
這是我的查詢代碼
$driversInformation = DriverInformation::all(['user_id','driver_fname','driver_mname','driver_lname',
'driver_birthday','years_driving_experience','years_driving_experience_quicktrans','start_year_of_exp_in_driving',
'start_year_of_exp_in_driving_in_quicktrans','educational_attainment','health_status','drug_test','marital_status',
'salary_level As Salary_range','license_registration','license_expiration','license_condition','medication_maintenance',
'training','driver_height','driver_weight','weight_status','emergency_contact_number','home_address_street_number',
'home_address_street','home_address_brgy','home_address_city','work_hours_range','work_shift','sleep_hours_range','smoker',
'created_at As year']);
uj5u.com熱心網友回復：
最簡單的方法是改變DriverInformation模型中的日期
/**
* The attributes that should be cast.
*
* @var array
*/
protected $casts = [
'created_at' => 'datetime:Y',
];
您可以在此處閱讀有關mutators 的更多資訊https://laravel.com/docs/8.x/eloquent-mutators#date-casting
uj5u.com熱心網友回復：
SQL查詢應該是
select Year(createdAt) as Year from Persons;
您可以在此處查看示例https://www.db-fiddle.com/f/d5j8icfiw8nvwZdKqhtr4h/0
uj5u.com熱心網友回復：
您可以使用 Carbon 類 -> \Carbon\Carbon::parse($item->created_at)->format('Y')
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/366226.html