使用Laravel Eloquent从数据库中获取记录，其中两个日期的差值等于一个值

Question

存在一个包含列的表。目标是计算查询中用户日期与当前日期之间的年差。usershire_datehire_date我想获取 as 和 now 之间的差异在数组中的记录，如hire_date|1989-10-07 02:06:44|[6,9,30]目前我已经尝试过这个<?phpnamespace App\Http\Controllers\API;use App\Http\Controllers\Controller;use Illuminate\Http\Request;use App\ServiceAwardYear;use App\User;use Carbon\Carbon;class LongServiceAwardController extends Controller{    public function index()    {        $records = [9,6];        foreach($records as $record){          $employees = User::where(Carbon::parse('hire_date')->diffInYears(Carbon::now()), $record)->get();     }}但它返回错误：message: "DateTime::__construct(): Failed to parse time string (hire_date) at position 0 (h): The timezone could not be found in the database".我该如何解决这个问题？

Answer 1

尝试使用 Carbon's 来获取日期，并与 进行比较，我们可以使用它将时间戳转换为日期：subYears()hire_datedate_format

$dates_ago = collect([15, 30, 35, 40])->map(function($num) {

    return Carbon::now()->subYears($num)->format('Y-m-d');

})->all();

User::whereIn(\DB::raw("date_format(hire_date, '%Y-%m-%d')"), $dates_ago)->get();

或仅使用TIMESTAMPDIFF()

User::whereIn(\DB::raw("TIMESTAMPDIFF(YEAR, hire_date, NOW())"), [15, 30, 35, 40])->get();