Re: Potentially annoying question about date ranges (part 2)

Thank you very much.

Sorry to be unclear, they are time stamped, and I wondered if someone
could give me ssome advise how I do this aggregation. In particular do
I not know how to write such a scalar function.

Anything re-usable lying around as examples somewhere?

el

on 10/4/06 9:46 PM Guy Rouillier said the following:
> Eberhard Lisse wrote:
>> I receive payments, but not every day (or even every week),
>> and I would like see how much I receive per week and/or per month. I
>> also need to compare different years.
>>
>> I also would like to see what the (accumulated) sum of the payments
>> is at the end of a given week, month.
>
> Timestamp each transaction, then use a GROUP BY clause to aggregate the
> numbers however you wish.  If the available date field extractions are
> not sufficient, write a scalar function of your own to accomplish what
> you need.
>

--
If you want to email me, replace nospam with el