Laravel Eloquent:如何在之间使用whereDate? [英] Laravel Eloquent: How to use whereDate with Between?

问题描述

我正在使用Laravel 5.5，我需要形成一个查询，其中只应匹配datetime列的日期部分，这相当于date(date_col)='2018-01-01'类的东西.我如何以口才的方式实现这一目标? WhereDate()返回日期部分，但是有什么方法可以合并两者?

I am using Laravel 5.5, I need to form a query where only date part of a datetime column should be matched, equivalent of date(date_col)='2018-01-01' kind of thing. How do I achieve this in Eloquent way? WhereDate() returns date part but is there some way to merge both?

谢谢

推荐答案

要合并whereDate和之间的日期，可以使用类似以下内容的方法:

For merging whereDate and between you can use something like this:

User::whereBetween(DB::raw('DATE(created_at)'), array($from_date, $to_date))->get();

sql:

select * from `users` where DATE(created_at) between '2018-02-01' and '2018-02-06'

这篇关于Laravel Eloquent:如何在之间使用whereDate?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！