Re: Date Questions

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Date Questions
Date: 2007-01-24 04:02:21
Message-ID: 20070124040221.GA8653@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Benjamin Smith 2007-01-24 04:48:28 Re: Postgresql.conf
Previous Message Robert Sanford 2007-01-24 03:46:24 Re: Date Questions