Re: select to_char(current_timestamp, 'YYYY-WW');

Поиск
Список
Период
Сортировка
От Alexander Farber
Тема Re: select to_char(current_timestamp, 'YYYY-WW');
Дата
Msg-id AANLkTim3XNiXyud4s-vWuZwFKRxZK0NhDk7Hw23QhpPS@mail.gmail.com
обсуждение исходный текст
Ответ на Re: select to_char(current_timestamp, 'YYYY-WW');  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: select to_char(current_timestamp, 'YYYY-WW');  (Alexander Farber <alexander.farber@gmail.com>)
Список pgsql-general
On Fri, Nov 5, 2010 at 1:21 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> WW is defined as starting the first week on the first day of the year.
> 2010 started on a Friday so the week number increments on Fridays.
>
> There are some other format codes with different behavior ...

Thank you, that is what I thought

But is there a format code for a week starting on Sunday or Monday?

Sorry, I can't find it at
http://www.postgresql.org/docs/8.4/interactive/functions-formatting.html

Regards
Alex

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

Предыдущее
От: "Carlo Stonebanks"
Дата:
Сообщение: How do you control IMMUTABLE PG PROC results?
Следующее
От: Alexander Farber
Дата:
Сообщение: Re: select to_char(current_timestamp, 'YYYY-WW');