I want to get a column like (datetime % 3600) / 60 as minute，But I use
$collection->columns('(datetime%3600)/60 as minute')
But I got SQL is `main_table`.`datetime%3600/60` AS `minute`
How I fixed It?
-
Welcome to SE, could you add more info on the qst. It's not clear enough.– Adarsh KhatriCommented Nov 21, 2016 at 4:11
-
Please give some more detail about your issue and also put your detail code.– Ashish JagnaniCommented Nov 21, 2016 at 5:55
Add a comment
|
1 Answer
Use Zend_Db_Expr for expressions instead of column names:
columns(new Zend_Db_Expr('(datetime%3600)/60 as minute'))
answered Nov 21, 2016 at 21:56
