Home / Questions / 217510
Accepted
Alberto Ortega
Asked: 2020-11-28 10:35:38 +0800 CST 2020-11-28 10:35:38 +0800 CST

Query between two date with time Eloquent

  • 772

Hi, I need to make a query between two date and time.

$data = Modelo::whereBetween('created_at', ['2018/11/10 12:00', '2018/11/11 10:30'])
->get();

But doing this query brings me all the results between the dates without taking into account the hours.

Dates are automatically saved with Eloquent

And apart I do the following to format the dates that I am going to look for:

Carbon::now()->parse($date)->format('Y-m-d H:i:s');
sql

2 Answers

  1. Best Answer

    To be able to do a search between 2 dates, within Laravelyou must proceed as follows:

    If the field of your database is of type, DATETIMEthe structure of your query must be as follows:

    $data = Modelo::whereBetween('created_at', ['2018/11/10 12:00:00', '2018/11/11 10:30:00'])->get();

    Or also

    $data = Modelo::whereBetween('created_at', ['2018-11-10 12:00', '2018-11-11 10:30'])
->get();

    You must keep in mind that for the calculation to be done as you require; your field should have this structure:

    YYYY-MM-DD HH:MM:SS->2018-11-12 12:52:12

    If for example you are going to occupy Carbon

    It can be like this:

    $fechaFormateada = Carbon::now();
$data = User::whereBetween('created_at', ['2018-11-24 15:49:02', $fechaFormateada])  
                                                                            ->get();
return $data;

    What about the FormattedDate property?

    If you do this:

    var_dump($fechaFormateada);

    You will get the following result

    object(Carbon\Carbon)#485 (3) { ["date"]=> string(26) "2018-11-28 00:53:33.425487" 
                                ["timezone_type"]=> int(3) ["timezone"]=> 
                                 string(3) "UTC" }

    That as you can see if it includes the seconds; to respect the data format required by the fieldDATETIME

    • 2

  2. What you can do is place two inputs like this in your html

    <input type="datetime-local" name="desde">
<input type="datetime-local" name="hasta">

    the datetime-local attribute will take both the date and the time since it is what you need and in your query you can use it in this way

    ->whereBetween('created_at', [$request->desde, $request->hasta])

    eye in your controller you must pass request in this way

    public function myController(Request $request)
{
     //aqui ira tu consulta (query) para generar lo que deseas
}

    I hope I have helped you and solved your question

    • 0