On 01/23/07 17:22, Robert Sanford wrote:
>
> January 07 of 2007 is a Sunday. Based on the documentation I would
> expect that date to be the first day of the second week of the year
> 2007. That's not what I'm getting. When I run:
Read the 'week' documentation carefully. ISO weeks start on Monday
M
> To: Robert Sanford
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Date Questions
>
> "Robert Sanford" <[EMAIL PROTECTED]> writes:
> > It appears to me that there is some inconsistency in the date
> > calculations for my PostgreSQL inst
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 01/23/07 17:22, Robert Sanford wrote:
> It appears to me that there is some inconsistency in the date
> calculations for my PostgreSQL install (version 8.0 on Win32).
>
> January 07 of 2007 is a Sunday. Based on the documentation I would
> expect t
"Robert Sanford" <[EMAIL PROTECTED]> writes:
> It appears to me that there is some inconsistency in the date
> calculations for my PostgreSQL install (version 8.0 on Win32).
extract(DOW) follows the convention that the week starts on Sunday,
but extract(WEEK) uses the ISO convention, which include
