Laravel 简单月份选择 [英] Laravel Simple Month Selection

问题描述

我尝试从日期字段fechas"(日期时间类型)中检索月份，其中使用 SQL 子句 MONTH 进行测试不起作用...感谢回复

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

              ->groupBy('cod_prov')
              ->skip(Input::get("jtStartIndex"))
              ->take(Input::get("jtPageSize"))
              ->get();

推荐答案

你可以使用隐藏 gem whereMonth:

You could use the hide gem whereMonth:

DB::table("ordenes")
    ->whereMonth('fecha', '=', '06')
    ->get();

我强烈建议您阅读 Builder.php 源代码以搜索其他 gem.:)https://github.com/laravel/framework/blob/4.2/src/Illuminate/Database/Query/Builder.php

I highly recommend to you read the Builder.php source to search for another gems. :) https://github.com/laravel/framework/blob/4.2/src/Illuminate/Database/Query/Builder.php

这篇关于Laravel 简单月份选择的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！