Question: Query db by MongoDate

[milosh012]

Hello,

first want to say that your extension is awesome!

I have one question... I have mongodb collection saved with models that have column type "Date". When I access that collection I see that column with Date type is actually MongoDate object.

My question is how I can query by that column? I have tried next scenarios with no success:

DB::connection('mongodb')->collection('names')->where('date', '<', new MongoDate())
DB::connection('mongodb')->collection('names')->where('date', '<', new DateTime())
DB::connection('mongodb')->collection('names')->where('date', '<', time())
DB::connection('mongodb')->collection('names')->where('date', '<', date('Y-m-d'))

Thanks,
Milos

[jenssegers]

For me, MongoDate() seems to be working. But new DateTime would be better I think.

[devbeans]

I am also having a problem with the dates, I have a script like this:

$from = new MongoDate(Input::get('from')); //from is in time format
$to = new MongoDate(Input::get('to')); // to is in time format
$between = array( $from, $to);
$leads = Lead::whereBetween('created_at', $between)->get();

I don't know what I'm missing but the date range is not working, is there something I am missing? Thanks for writing a great extension btw.

Cheers,
Albert

[jenssegers]

I'm looking into this right now.

[jenssegers]

I did not encounter any problems with dates. Check the date tests in 93e53ec

[devbeans]

Awesome, got some tips from your tests. Thank you

[jenssegers]

Added some more date tweaks and a bit of documentation: https://github.com/jenssegers/Laravel-MongoDB#dates

[jenssegers]

I added Carbon date support to the latest version. Can anyone report back if he's having problems with these changes?

[sebastiaanluca]

Could you perhaps quickly explain how to get MongoDate objects converted to Carbon instances? Whenever I read out data, the created_at and updated_at fields are always of the MongoDate type.

[atapatel]

I am facing the issue with new version..

[jkpatil211]

@sebastiaanluca : u can use MongoDate::toDateTime as given in following link
http://php.net/manual/en/mongodate.todatetime.php

[saraht129]

@jenssegers The whereBetween query doesn't work with Carbon date, only MongoDate. Using v2.2.4.

    $startDate = Carbon::createFromDate(2015, 4, 1);
    $endDate = Carbon::createFromDate(2015, 4, 30);
    $users = User::whereBetween('created_at', array($startDate, $endDate))->get();
    //Return empty result

    $startDate = new MongoDate(Carbon::createFromDate(2015, 4, 1)->timestamp);
    $endDate = new MongoDate(Carbon::createFromDate(2015, 4, 30)->timestamp);
    $users = User::whereBetween('created_at', array($startDate, $endDate))->get();
    //Return correct results

Is the Carbon date support not applicable to this case? Thanks!

[thiagoalves-dev]

I am facing the issue with new version..²

[mshahamirian]

@saraht129 @jenssegers I've tired your solution and still get empty result! Also tried (for example)
User::where('created_at','>',$startDate)->where('created_at','<',$endDate)->get();
still get empty result.
I don't know why it doesn't work with more than one where clause 😞