[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