Skip site navigation (1) Skip section navigation (2)

How to GROUP results BY month

From: "Oliveiros Cristina" <oliveiros(dot)cristina(at)marktest(dot)pt>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: How to GROUP results BY month
Date: 2008-07-15 12:12:39
Message-ID: 009b01c8e674$13b716e0$ec5a3d0a@marktestcr.marktest.pt (view raw or flat)
Thread:
Lists: pgsql-sql
Howdy, all,

I have a problem.

I have a table which one of the fields is of type date.

I need to obtain the totals of the other fields in a  by-month basis
IS there any easy way to do this using the GROUP BY or any other construct?

Thanks in advance for your kind help

Best,
Oliveiros

In response to

Responses

pgsql-sql by date

Next:From: A. KretschmerDate: 2008-07-15 12:31:57
Subject: Re: How to GROUP results BY month
Previous:From: Simon RiggsDate: 2008-07-15 06:17:43
Subject: Re: Rollback in Postgres

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group