Re: Grouping by DATETIME in sql
Dave,
How about:
SELECT count(*), extend(my_datetime, day to day)
FROM my_table
GROUP BY 2;
It works in 7.10. I don't know about 4.10, but I'm not aware
of any major changes which would stop it.
--Craig (craig@chemistry.utah.edu)
>
> Having gone thru the manuals I cannot fathom how to group by using the
> datetime function. I have a field defined datetime(year to minute) and want to
> group the rows according to individual days. ie how many rows per day. This is
> using 4.10 SQL.
>