we are trying to filter out orders that were created longer than 60 minutes ago with status pending. We are having some problems with the date/time functions
We tried: - date('Y-m-d H:m:s') and subtracting hours - and Mage::getModel('core/date')
But both are not giving me the correct date/time as I see is being used for the column updated_at.
Question: What date/time function or method should I use to find a date-time that corresponds to the date-time that is used for the updated_at column in orders? (so when I have the correct date-time I can subtract and select orders)
$date = $this->get_offset_hours(); $orders = Mage::getModel('sales/order')->getCollection() ->addFieldToFilter('state', 'new') ->addFieldToFilter('status', 'pending') ->addFieldToFilter('updated_at', array('lt' => $date));