PHP Active Record在条件下使用NOW（）

Question

I'm trying to find all rows that have an end_time greater than the current time. In MySQL I believe I can use:

SELECT * FROM Table WHERE end_time > DATE(NOW());

So, I'm trying to use:

$options = array();
$options['conditions'] = array('end_time > ?', array('DATE(NOW())'));
$results = Model::all($options);

But it doesn't appear to be working. How can I fix this?

Answer 1

Well, one way to fix this is to use:

$options['conditions'] = array('end_time > DATE(NOW())');

Wondering if this is the best solution.