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
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 that date to be the first day of the second week of the year
2007. That's not what I'm getting. Whe
