Re: [SQL] grouping by date increments

[Tom Lane]

"Graham Vickrage" <[EMAIL PROTECTED]> writes:
> I have written this successfully but need to get the count in time
> increments such as per day/week/month.

Perhaps use GROUP BY date_part(...).  See 
stgresql.org/devel-corner/docs/postgres/functions-datetime.htm
for doco on date_part().

                        regards, tom lane