Subject | Re: [firebird-support] Re: Count by day |
---|---|
Author | Woody (TMW) |
Post date | 2004-12-03T17:40:50Z |
>If you only need to single out one event, then you could do something like
> > 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.
>
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)