[Wolves] Fwd: Fwd: mysql select help
Wayne Morris
waynelists at machx.co.uk
Thu Mar 8 14:52:48 UTC 2012
On 08/03/2012 14:39, Mike Hingley wrote:
> A cohort date sounds like duplication of data here. I think the issue
> - the real issue might be using a timestamp rather than a date field.
>
> How about using date_format to strip the time elrment, and group on that.
>
> The advantage there is no schema change.
>
Sorry, just checked my database and i was thinking of another field
which was a timestamp - this is a simple 'date' field.
cheers
More information about the Wolves
mailing list