I want to do a query like this: SELECT posts.*, TIMESTAMPDIFF(SECOND, posts.created_at, (SELECT DATE_ADD(NOW(), INTERVAL 3 HOUR))) as difference FROM posts;
so that my post records will have a magical "difference" virtual attribute containing this number of seconds... I am not sure how to properly pass the "TIMESTAMPDIFF(SECOND, posts.created_at, (SELECT DATE_ADD(NOW(), INTERVAL 3 HOUR))) as difference" part into the facets method when performing a search... ? Can anyone give me some guidance on how to do this? Thanks! -patrick -- You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en.
