Home » Answers » Laravel- How to filter if date-time field with AM or PM date format?

Laravel- How to filter if date-time field with AM or PM date format?

Post author By Mubarak Hossain
Post date January 22, 2022

Laravel query filter if date-time field with AM or PM date format. I will show between query on “open_at” and “close_at” field by using mysql STR_TO_DATE method.

Date Time field with AM or PM query:

//Use PHP Carbon library
use Carbon\Carbon;
	
//Laravel where raw query
->whereRaw("STR_TO_DATE('". Carbon::now()->format('Y-m-d h:i A') ."', '%Y-%m-%d %h:%i %p') BETWEEN STR_TO_DATE(open_at, '%Y-%m-%d %h:%i %p') AND STR_TO_DATE(close_at, '%Y-%m-%d %h:%i %p')")

Date Time field with AM or PM query:

Related Answers