Laravel equivalent query builder

Question

How to convert below query into Laravel equivalent query builder

SELECT * FROM `table_name` WHERE '03-05-2017 09:30' BETWEEN `start_date` AND `end_date` AND `who_should`='VV000'

I tried using whereBetween but not working as expected.

Generally column_name BETWEEN '03-05-2017 09:30' AND '10-05-2017 09:30' is the format I am unable to understand the Logic where you are checking the constant value... — Akshay Khale
– Akshay Khale, Commented May 1, 2017 at 7:26
You can use where > and < or you can add raw where clause in whereRaw also. — Akshay Khale
– Akshay Khale, Commented May 1, 2017 at 9:10

Sagar Jajoriya · Accepted Answer · 2017-05-01 09:09:02Z

2

$given_time = "03-05-2017 09:30";    
\DB::table('table_name')
        ->whereRaw(" '$given_time' Between start_date  and end_date ")
        ->where("who_should", "=", "VV000")
        ->get();

answered May 1, 2017 at 9:09

Sagar Jajoriya

2,3751 gold badge12 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ashanrupasinghe · Accepted Answer · 2017-05-01 07:26:47Z

1

$date = new Carbon\Carbon('03-05-2017 09:30'); 
        $date_string=$date->toDateTimeString();

        $data_set = DB::table('table_name')
        ->select(DB::raw('*'))
        ->where('start_date', '<', $date_string )
        ->where('end_date', '>', $date_string )     
        ->where('who_should','=','VV000')
        ->get();

Try above code

edited May 1, 2017 at 7:26

answered May 1, 2017 at 7:17

ashanrupasinghe

7861 gold badge10 silver badges25 bronze badges

9 Comments

Zack Over a year ago

I dont know why its showing error syntax error, unexpected '$data_set' (T_VARIABLE)

ashanrupasinghe Over a year ago

missed semicolon $date_string=$date->toDateTimeString();

Zack Over a year ago

Still getting this syntax error, unexpected '/', expecting ',' or ';'

Zack Over a year ago

Its same, no difference

ashanrupasinghe Over a year ago

I have changed date_string to $date_string previously, now there should not contain an error, You may also need to call use Carbon; before defining your controller class

|

Collectives™ on Stack Overflow

Laravel equivalent query builder

2 Answers 2

Comments

9 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

9 Comments

Your Answer

Sign up or log in

Post as a guest

Related