Re: Date Questions - Mailing list pgsql-general

From Tom Lane
Subject Re: Date Questions
Date
Msg-id 5854.1169595609@sss.pgh.pa.us
Whole thread Raw
In response to Date Questions  ("Robert Sanford" <rsanford@trefs.com>)
Responses Re: Date Questions  ("Robert Sanford" <rsanford@trefs.com>)
List pgsql-general
"Robert Sanford" <rsanford@trefs.com> 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 includes weeks
starting on Monday.  No, it's not super consistent, but hardly
anything about date/time conventions is :-(

            regards, tom lane

pgsql-general by date:

Previous
From: Harald Fuchs
Date:
Subject: Re: psql substitution variables
Next
From: Ron Johnson
Date:
Subject: Re: Date Questions