Re: Find all the dates in the calendar week?

Поиск
Список
Период
Сортировка
От Thomas Lockhart
Тема Re: Find all the dates in the calendar week?
Дата
Msg-id 39648E4F.2C9A91F9@alumni.caltech.edu
обсуждение исходный текст
Ответ на RE: Find all the dates in the calendar week?  (Karel Zak <zakkr@zf.jcu.cz>)
Ответы Re: Find all the dates in the calendar week?  (Karel Zak <zakkr@zf.jcu.cz>)
Список pgsql-general
> ISO-week: week that has more than 4 day and start in Sunday.
> In future I try implement 'IW' that is ISO-week, but now I work on different
> things.
> In current 7.0 is probably better for week operations use
> date_part('week', TIMESTAMP) than to_char().

Note that the above returns ISO-week, not some Sun-Sat thing ('dow' ==
"day of week" does that). I haven't yet implemented ISO-year (Karel?)
which would seem to be an essential piece to use ISO-week effectively.

                        - Thomas

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

Предыдущее
От: Thomas Lockhart
Дата:
Сообщение: Re: [HACKERS] pl/pgsql function out parameters
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Partial indices