laravel中的wherebetween是哪里? [英] is whereBetween in laravel inclusive?

问题描述

在我的数据库中，有4个学生:

In my database there are 4 students:

第一名学生的created_at = 2016-05-12 02:23:51

1st Student's created_at = 2016-05-12 02:23:51

第二名学生的created_at = 2016-05-27 07:37:45

2nd Student's created_at = 2016-05-27 07:37:45

第三名学生的created_at = 2016-05-29 07:40:29

3rd Student's created_at = 2016-05-29 07:40:29

第四名学生的created_at = 2016-05-29 07:50:05

4th Student's created_at = 2016-05-29 07:50:05

为什么我的代码只返回第一名学生?

Why does my code only returns the 1st student?

$students = Student::select('id as ID_NO', 'fname as Firstname', 'lname as Lastname', 'created_at')
                             ->whereBetween('created_at', 
                              [Carbon::createFromDate(2016, 5, 12)->toDateString(),
                               Carbon::createFromDate(2016, 5, 27)->toDateString()])

第一名和第二名学生应归还. "to"部分包含在whereBetween之间还是我的代码有问题?

The 1st and 2nd student should be returned. Is the "to" part inclusive in whereBetween or there's something wrong with my code ?

我需要你们的帮助.预先感谢！

I need your help guys. Thanks in advance!

推荐答案

您需要将created_at格式化为Y-m-d格式. 请查看更改:

You need to format your created_at to Y-m-d format. Please see the change:

$students = Student::select('id as ID_NO', 'fname as Firstname', 'lname as Lastname', 'created_at')
                                 ->whereBetween(DB::raw('date(created_at)'), 
                                  [Carbon::createFromDate(2016, 5, 12)->toDateString(),
                                   Carbon::createFromDate(2016, 5, 27)->toDateString()])

这篇关于laravel中的wherebetween是哪里?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！