[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