CODEWITHSUNDEEP
mysqllaravelphpmyadmineloquent
Manas
Manas

Reputation: 3330

how to get the values of specified date range?

I am trying to retrieve today's values from the table, in my table i have created_at columns, which is a timestamp automatically assigned when a row is inserted. I also have a send_at column where i manually insert datetime, when i query send_at with a range it works, but when i query created_at column i get nothing back.

  $campaigns = SmsCampaign::whereBetween('created_at', array('2017-03-20 12:00:00','2017-03-20 23:59:00'))->paginate(10);

        return view('sms_campaign.smscampaign')->with('campaigns', $campaigns);

enter image description here

model:

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class SmsCampaign extends Model
{


protected $table = 'sms_campaign';
protected $primaryKey = 'id';
//public $timestamps = false;
protected $fillable = [ 'campaign_name', 'content', 'phone_no_list',  'send_time', 'status', 'merchant_id', 'send_type'];




}

Upvotes: 1

Views: 41

Answers (1)

Alexey Mezenin
Alexey Mezenin

Reputation: 163768

Pass Carbon instances:

SmsCampaign::whereBetween('created_at', [
        Carbon::parse('2017-03-20 12:00:00'),
        Carbon::parse('2017-03-20 23:59.00')
    ])->paginate(10);

Upvotes: 1

Related Questions