[Wolves] Fwd: Fwd: mysql select help

[Mike Hingley]

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.  

----- Forwarded message -----
From: "Dan Dart" <dandart at googlemail.com>
Date: Thu, Mar 8, 2012 14:03
Subject: [Wolves] Fwd: mysql select help
To: "Wolverhampton Linux User Group" <wolves at mailman.lug.org.uk>

Alternatively make a CohortDate - an index date just containing the
time at midnight the appropriate day
then group by this field

_______________________________________________
Wolves LUG mailing list
Homepage: http://www.wolveslug.org.uk/
Mailing list: Wolves at mailman.lug.org.uk
Mailing list home: https://mailman.lug.org.uk/mailman/listinfo/wolves

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.lug.org.uk/pipermail/wolves/attachments/20120308/11f33be2/attachment-0001.htm>