Re: Date Questions

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: Date Questions
Дата
Msg-id 20070124040221.GA8653@wolff.to
обсуждение исходный текст
Ответ на Re: Date Questions  (Ron Johnson <ron.l.johnson@cox.net>)
Список 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 по дате отправления:

Предыдущее
От: "Robert Sanford"
Дата:
Сообщение: Re: Date Questions
Следующее
От: Ken Johanson
Дата:
Сообщение: Example of RETURNING clause to get auto-generated keys from INSERT