Answers for "date and time comparison laravel query"

datediff in hour query builder laravel

DB::table('product')->whereRaw('DATEDIFF(exp_date,current_date) < 15')->get();

laravel compare date timestamp

$now = Carbon::createFromFormat('m/d/Y H:i:s', Carbon::now());
$scheduledAt = Carbon::createFromFormat('m/d/Y H:i:s', $this->smsMessageRequest->scheduled_at);
return $now->gte($scheduledAt->addHours(2));

laravel date diff

$expDate = Carbon::now()->subDays(15));
Table::whereDate('exp_date', '<',$expDate);