date_trunct() and start of week

Поиск
Список
Период
Сортировка
От Thomas Kellerer
Тема date_trunct() and start of week
Дата
Msg-id hemtn6$drb$1@ger.gmane.org
обсуждение исходный текст
Ответы Re: date_trunct() and start of week  (Adrian Klaver <aklaver@comcast.net>)
Re: date_trunct() and start of week  (Thom Brown <thombrown@gmail.com>)
Re: date_trunct() and start of week  (Thom Brown <thombrown@gmail.com>)
Список pgsql-general
Hi,

while using date_trunc('week', some_date) to get the date of the first day of the week I noticed that it was working as
expected:Monday is considered the start of the week.  

I assume this depends on some locale setting, but I can't figure out which it is, so I can make sure this is not
"accidently"changed. I tried changing LC_TIME (American_America) but that still returned Monday as the first day (my
understandingis that in the States Sunday is considered the start of the week) 

Any pointers are appreciated (did I miss it in the manual?)

Regards
Thomas


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

Предыдущее
От: Bill Todd
Дата:
Сообщение: Re: How use input parameter as path to COPY in function?
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: date_trunct() and start of week