Postgres Pro
Downloads
Home   >   mailing lists

How to GROUP results BY month - Mailing list pgsql-sql

From Oliveiros Cristina
Subject How to GROUP results BY month
Date
Msg-id 009b01c8e674$13b716e0$ec5a3d0a@marktestcr.marktest.pt
Whole thread Raw
In response to Re: Rollback in Postgres  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Responses Re: How to GROUP results BY month  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Re: How to GROUP results BY month  (Herouth Maoz <herouth@unicell.co.il>)
Re: How to GROUP results BY month  (Herouth Maoz <herouth@unicell.co.il>)
Re: How to GROUP results BY month  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Rollback in Postgres
Next
From: "A. Kretschmer"
Date:
Subject: Re: How to GROUP results BY month