DEV Community

loading...

Laravel's Eloquent whereTime() filtering method

cooldashing24 profile image Vishnu Damwala Originally published at meshworld.in ・1 min read

Laravel provides many additional methods other than standard methods. You might be familiar with where(), orWhere(), whereJsonContains() or whereJsonLength(). And these additional methods are worth checking.

In this article, we will see whereTime(), one of the supplementary methods that comes in handy when you want to compare the table's field value with a specific time.

whereTime()

The whereTime() method helps to get records matching the specific time.

Sytnax

whereTime('fieldName', 'operator', 'time');
Enter fullscreen mode Exit fullscreen mode
  • The first parameter is fieldName with which a comparison is to be done.
  • The second parameter is an operator for comparison, such as =, <>, >, >=, < or <=.
  • The third parameter is a time for comparison in HH:MM:SS.

Example

$users = User::whereTime('login_at', '11:12:31')->get();
Enter fullscreen mode Exit fullscreen mode

Read the complete post on our site Laravel's whereTime Model Method

Read others post on our site MeshWorld

Happy 😄 coding

With ❤️ from 🇮🇳

Discussion (0)

pic
Editor guide