laravel mongodb日期与mongodb iso日期

飞鱼计划

于 2023-05-29 15:49:37 发布

阅读量245

点赞数 1

文章标签： laravel php

本文链接：https://blog.csdn.net/qq_35669659/article/details/130929915

版权

$users = User::whereBetween(
             'created_at', array(
                 Carbon::createFromDate(2015, 10, 1),
                 Carbon::createFromDate(2015, 10, 31)
             )
         )->get();

<?php
 
use Jenssegers\Mongodb\Model as Eloquent;
 
class User extends Eloquent {
 
    use SoftDeletingTrait;
 
    /**
     * Collection for Model
     *
     * @var String
     */
    protected $collection = "users";
 
    /**
     * Connection for model
     *
     * @var type
     */
    protected $connection = 'mongodb';
 
    protected $dates = array('created_at');
}

$users = User::where('created_at', '>', new DateTime('-1 day'))->get();

$start = new MongoDate(strtotime("2015-10-01 00:00:00"));
$stop = new MongoDate(strtotime("2015-10-31 00:00:00"));
 
$users = DB::collection('users')->whereBetween('created_at', array($start, $stop))->get();