Subject Re: [firebird-support] Re: Count by day
Author Woody (TMW)
>
> > A "text" log file or a table containing log information separated
> > by fields?
>
> I thought the right word, just didn't type it. I have a lot *table*
> with a date/time field that I need count by day.
>

If you only need to single out one event, then you could do something like
this:

Select sum(Event), DateOfEvent From EventTable
Where Event = ??
Group By DateOfEvent

Now, DateOfEvent could be several things. If you are only storing the date
portion inside the table, it could simply refer to the field. If you are
also storing time, then you would need to either use a function (UDF) to get
the date or one of the internal functions of FB, for example CAST.

HTH
Woody (TMW)