Postgres Pro
Downloads
Home   >   mailing lists

getting weekly total based on daily... - Mailing list pgsql-general

From jerome
Subject getting weekly total based on daily...
Date
Msg-id 200301271652.50521.jerome@gmanmi.tv
Whole thread Raw
Responses Re: getting weekly total based on daily...
List pgsql-general
Tree view 
i was wondering is there a built-in funtion that gets the weeknumber based on
date..

lets say Jan 1-7 is week 1
                   8-14 is week 2

then
Feb 1-7 week 1

etc..

TIA

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pg_xlog safety
Next
From: Bruce Momjian
Date:
Subject: Re: [PERFORM] optimizing query