Postgres Pro
Downloads
Home   >   mailing lists

date_trunct() and start of week - Mailing list pgsql-general

From Thomas Kellerer
Subject date_trunct() and start of week
Date
Msg-id hemtn6$drb$1@ger.gmane.org
Whole thread Raw
Responses 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>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Bill Todd
Date:
Subject: Re: How use input parameter as path to COPY in function?
Next
From: Adrian Klaver
Date:
Subject: Re: date_trunct() and start of week