Postgres Pro
Downloads
Home   >   mailing lists

Re: Find all the dates in the calendar week? - Mailing list pgsql-general

From Thomas Lockhart
Subject Re: Find all the dates in the calendar week?
Date
Msg-id 39648E4F.2C9A91F9@alumni.caltech.edu
Whole thread Raw
In response to RE: Find all the dates in the calendar week?  (Karel Zak <zakkr@zf.jcu.cz>)
Responses Re: Find all the dates in the calendar week?  (Karel Zak <zakkr@zf.jcu.cz>)
List pgsql-general
Tree view 
> ISO-week: week that has more than 4 day and start in Sunday.
> In future I try implement 'IW' that is ISO-week, but now I work on different
> things.
> In current 7.0 is probably better for week operations use
> date_part('week', TIMESTAMP) than to_char().

Note that the above returns ISO-week, not some Sun-Sat thing ('dow' ==
"day of week" does that). I haven't yet implemented ISO-year (Karel?)
which would seem to be an essential piece to use ISO-week effectively.

                        - Thomas

pgsql-general by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: [HACKERS] pl/pgsql function out parameters
Next
From: Tom Lane
Date:
Subject: Re: Partial indices