php – Laravel Simple Month Selection-ThrowExceptions

Exception or error:

y tried retrieve month from date field “fechas” (datetime type) where testing with SQL clause MONTH not works… thanks for replies

            $data = DB::table("ordenes")
              ->select(array('*', DB::raw('((cant_ped)*(precio_unit)) as sum_pedidos'), DB::raw('((cant_pend)*(precio_unit)) as sum_pends'), DB::raw('((cant_rec)*(precio_unit)) as sum_recibidos'), DB::raw('(((cant_pend)*(precio_unit)) + ((cant_rec)*(precio_unit))) as sum_importe')))
              ->where('cod_prov', '<>', 0)

              ///////////// line ERROR
              ->where('MONTH(fecha)', '=', '06')

              ///////->where('MONTH(fecha)', '=', '2014-06-20') ///test OK

How to solve:

You could use the hide gem whereMonth:

    ->whereMonth('fecha', '=', '06')

I highly recommend to you read the Builder.php source to search for another gems. 🙂


You may try whereRaw method

$data = DB::table("ordenes")
    // ...
    ->whereRaw('MONTH(fecha) = ?', [06])
    // ...


You could use something like this

$users = Model::whereMonth('created_at', '12')->get();

Leave a Reply

Your email address will not be published. Required fields are marked *