On Fri, Nov 27, 2009 at 08:13, Thomas Kellerer <spam_eater@xxxxxxx> wrote: [...] > I'm just curious which setting defines whether monday or sunday is > considered the "first day in a week" Read 9.9.2 on http://www.postgresql.org/docs/8.1/static/functions-datetime.html and you will see that even if you find such setting, date_trunc() will always return monday as start of week: =========[snip] source is a value expression of type timestamp or interval. (Values of type date and time are cast automatically, to timestamp or interval respectively.) field selects to which precision to truncate the input value. The return value is of type timestamp or interval with all fields that are less significant than the selected one set to zero (or one, for day and month). =========[snip] Atleast that's how I interpret the last parenthesis in the paragraph. -- - Rikard -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
