如何更改时区 操作created_at的时间戳

Question

>我有一个雄辩的查询，我想更改created_at减去 2 小时。

查询是

AirtimeTransaction::select('airtime_transactions.id',
'airtime_transactions.created_at',
'airtime_transactions.request_id', 
DB::raw('IF(airtime_transactions.result_desc IS NULL or airtime_transactions.result_desc = "", "Failed", airtime_transactions.result_desc) as result_desc'))
->groupBy('airtime_transactions.id');

我想从答案中减去两个小时airtime_transactions.created_at

有人在这里提供帮助

Answer 1

您可以在AirtimeTransaction模型中使用 Eloquent Accessor：

public function getCreatedAtAttribute($createdAt)
{
return (new Carbon($createdAt))->subHours(2);
}