Re: Re: First Saturday and Last Saturday of a month

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Re: First Saturday and Last Saturday of a month
Дата
Msg-id 21131.997323119@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: First Saturday and Last Saturday of a month  (Allan Engelhardt <allane@cybaea.com>)
Список pgsql-general
Allan Engelhardt <allane@cybaea.com> writes:
> Last Saturday problem is similar to above except for some sign
> reversals, but more interesting as you need the number of days in the
> month.

I'd be inclined to take the first day of the *next* month (relatively
easy to figure), and then back up to a Saturday using the 'dow' value
for that day.

            regards, tom lane

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

Предыдущее
От: "Yusron Hilmy"
Дата:
Сообщение: getting result information of DECLARE CURSOR statement
Следующее
От: Allan Engelhardt
Дата:
Сообщение: Re: Re: First Saturday and Last Saturday of a month