Re: extract (dow/week from date)

Поиск
Список
Период
Сортировка
От Jim C. Nasby
Тема Re: extract (dow/week from date)
Дата
Msg-id 20050821165904.GK95876@pervasive.com
обсуждение исходный текст
Ответ на Re: extract (dow/week from date)  (Clodoaldo Pinto <clodoaldo.pinto@gmail.com>)
Ответы Re: extract (dow/week from date)  (Clodoaldo Pinto <clodoaldo.pinto@gmail.com>)
Список pgsql-general
On Sun, Aug 21, 2005 at 08:00:45AM -0300, Clodoaldo Pinto wrote:
> Of course it would be even better if we could pass parameters to the
> functions changing its behavior such as sunday/monday as the first day
> or 0-1 as the first day.

FWIW, it seems most things that support changing first day of the week
to be something other than <default> do it through a global setting.
ISTM that would be much less error prone than having to make sure you
used it in all your function calls (not to mention a lot less typing...)
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software        http://pervasive.com        512-569-9461

В списке pgsql-general по дате отправления:

Предыдущее
От: "John Craddock"
Дата:
Сообщение: Windows Installer
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: ORDER BY time consuming