Saku Ytti wrote:
> I have timestamp(14) variable, let's call it bar, table shall be foo.
> I'd like to sort according to date, not whole timestamp, so that
> year/month/day match. And only display each date once, and report
> how many matches there were, sorted. Something like:
> select *, count(*) from foo group by bar;
> How to implement order? I only managed to get syntaxt error.
> --ytti - ::3585:0512:1378
Use somthing like:
DATE_FORMAT( bar, '%Y%m%d' ) as Date
PS: Sorry for the late answer, I was on vacation.