I’ve been puzzeling over this for a while and haven’t been able to find a good solution.
I have table/model(created by gii) with the columns id, created_at, completed_at and name.
I’m tring to get the total amount of time from completed_at minus created_at for each record.
I know i can create a getTotalTime() function in my model but it would be much faster if i could somehow do "TIMEDIFF(completed_at, created_at) as total" in sql instead of converting the date to seconds and then trying to divide it down to the time.
I’ve tried $criteria->select = '*, TIMEDIFF(completed_at, created_at) AS
total'; in the search funtion of my model but no luck there.
Is there a way to create a virtual attribute/column that allows for a simple sql select as part of my already created model?
Let me know