Data is not coming when comparing current time between 2 times to fetch data in Laravel. Both times are saved in the database as timestamp and in query also I am using timestamp. Below is the code i wrote:-

$current_date = strtotime(date('d-m-Y H:i:s'));
        
$bookings = MachineBooking::with('userDetail')->where('machine_id', $machine_id)->where('time_from', '>=', $current_date)->where('time_to', '<', $current_date)->get();

"time_from" and "time_to" both timestamps are saved in bigint format in database. I entered timestamp using search option in direct database also still data did not come. Can someone please tell me where i am making mistake.

CodePudding user response：

You not describe what database you use. But maybe you can change to Y-m-d H:i:s format:

$current_date = strtotime(date('Y-m-d H:i:s'));

but strtotime is return int not bigint.

CodePudding user response：

I hope I will help you firstly You must cast the date in Model MachineBooking

protected $casts = ['time_from' => 'datetime:Y-m-d H:i:s',time_to =>'datetime:Y-m-d H:i:s'];

secondly cast current date with same format of time_from and time_to

$current_date = strtotime(date('Y-m-d H:i:s'));

CodePudding user response：

Please change your code with:

$current_date = strtotime(date('Y-m-d H:i:s'));