Laravel's Eloquent whereTime() filtering method

cooldashing24

Vishnu Damwala

Posted on January 29, 2021

Laravel's Eloquent whereTime() filtering method

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 🇮🇳

💖 💪 🙅 🚩
cooldashing24
Vishnu Damwala

Posted on January 29, 2021

Join Our Newsletter. No Spam, Only the good stuff.

Sign up to receive the latest update from our blog.

Related