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$ (view raw, whole thread or download thread mbox)
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


In response to


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-2017 The PostgreSQL Global Development Group