Return to Question

edited body; edited tags

Source Link

edited Nov 21, 2016 at 8:28

I want to get a column like (datetime%3600)/60(datetime % 3600) / 60 as minute，But I use

$collection->columns('(datetime%3600)/60 as minute')

But I got sqlSQL is main_table.datetime%3600`main_table`.`datetime%3600/60 AS minute60` AS `minute`

How I fixed It. Thank you.?

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. Thank you.

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?

collection filter sql

Source Link

asked Nov 21, 2016 at 4:01

How to get column such as that By collection

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. Thank you.

collection