[vox-tech] MySQL question: making stats out of orders

Bill Kendrick nbs at sonic.net
Tue Dec 1 22:41:32 PST 2009


On Wed, Dec 02, 2009 at 12:37:19AM -0600, Chanoch (Ken) Bloom wrote:
> Then you have to throw in a conversion function that truncates it to the
> date in order for the `group by` to work correctly. I'm not sure what
> function that is, but you can play around with the functions listed at 
> http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html

In my original follow-up, I did a "FROM_DAYS(TO_DAYS(...))" trick,
which would probably work.

Thanks!

-- 
-bill!
Sent from my computer


More information about the vox-tech mailing list