Re: Date Questions - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Date Questions
Date
Msg-id 20070124040221.GA8653@wolff.to
Whole thread Raw
In response to Re: Date Questions  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-general
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 Mondays. So
2007-01-07 would be the last day of the first week of 2007.

So in some sense dow is inconsistant with week, but both are working
consistant with the documentation.

pgsql-general by date:

Previous
From: "Robert Sanford"
Date:
Subject: Re: Date Questions
Next
From: Ken Johanson
Date:
Subject: Example of RETURNING clause to get auto-generated keys from INSERT