Cannot filter the data collection

Question

I'm trying to filter the data collection from 4 hours to now and I have the below code but its not working.

public function getWishlistProduct($wishlistid){

$to = date("Y-m-d h:i:s");
$from = strtotime('-4 hours', strtotime($to));
$from = date('Y-m-d h:i:s', $from); 

$wishlist= $this->getCollection()->addFieldToFilter('wishlist_id', ['eq'=>$wishlistid])
                                    ->addFieldToFilter('added_at', array('from'=>$from, 'to'=>$to));
return $wishlist;
      
}

Could anyone please help?

Answer 1

I have solved this issue by using the time() function and the updated code as below. Hope it may helpful to someone:

public function getWishlistProduct($wishlistid){

    $time = time();
    $to = date('Y-m-d H:i:s', $time);
    $lastTime = $time - 14400; //60*60*4
    $from = date('Y-m-d H:i:s', $lastTime);

    $wishlist= $this->getCollection()->addFieldToFilter('wishlist_id', ['eq'=>$wishlistid])
                                        ->addFieldToFilter('added_at', array('from'=>$from, 'to'=>$to));
    return $wishlist;
          
    }