Postgres Pro
Downloads
Home   >   mailing lists

Grouping by week - Mailing list pgsql-sql

From Caleb Simonyi-Gindele
Subject Grouping by week
Date
Msg-id 000001c47bfc$69d79e50$c201a8c0@borderveygqj37
Whole thread Raw
In response to New PHP + PostgreSQL group on Google Groups2  (dguarneri@satx.rr.com (N. David))
Responses Re: Grouping by week  (Oliver Elphick <olly@lfix.co.uk>)
List pgsql-sql
Tree view 
I'm using 

SELECT EXTRACT(WEEK FROM trans_date), SUM(tran_amount) ... GROUP BY
trans_date 

and it is being used to group sales results by week. It works really well. 

What I'm wondering is if I can shift the week from a Mon-Sun
articulation(default with Postgre) to a Sun-Sat sequence. I need it that way
in order to comply with a legacy stats system.

Thanks,
Caleb

pgsql-sql by date:

Previous
From: dguarneri@satx.rr.com (N. David)
Date:
Subject: New PHP + PostgreSQL group on Google Groups2
Next
From: Oliver Elphick
Date:
Subject: Re: Grouping by week