I want to select the row based on the current time in laravel. I have a query but it give a empty result.
$price_calc = DB::table('trip_price_fixing')
->select(DB::raw("DATE(D.datumTijd),
CASE WHEN TIME(D.datumTijd) BETWEEN '08:00:00' AND '14:00:00' THEN 1
WHEN TIME(D.datumTijd) BETWEEN '14:00:00' AND '20:00:00' THEN 2
WHEN TIME(D.datumTijd) BETWEEN '20:00:00' AND '24:00:00' THEN 3
END "));
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire