From: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: date_trunct() and start of week |
Date: | 2009-11-27 08:16:41 |
Message-ID: | heo1t9$l8b$1@ger.gmane.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Rikard Bosnjakovic, 27.11.2009 08:49:
> [...]
>> 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.
Hmm, I don't see that in there.
It just states that the field will be set to "zero". But does zero refer to a Monday or a Sunday?
Regards
Thomas
From | Date | Subject | |
---|---|---|---|
Next Message | bbhe | 2009-11-27 08:26:46 | return value for PQbinaryTuples |
Previous Message | Rikard Bosnjakovic | 2009-11-27 07:49:42 | Re: date_trunct() and start of week |