Re: date_trunct() and start of week

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:50:33
Message-ID: heo3sp$q5v$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thomas Markus, 27.11.2009 09:41:
> Hi,
>
> not all to zero : "that are less significant than the selected one set
> to zero (or one, for day and month)"
>
Sorry, I missed the "or one" part.

> see
> http://www.postgresql.org/docs/8.1/static/functions-datetime.html#FUNCTIONS-DATETIME-EXTRACT
> dow: "The day of the week (0 - 6; Sunday is 0)"

So essentially it *is* always returning Monday independently of any setting.

Thanks for your help

Regards
Thomas

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2009-11-27 08:52:55 Re: Is there any reason why databases cannot have a binary formatted datatype?
Previous Message Andrew Maclean 2009-11-27 08:48:47 Is there any reason why databases cannot have a binary formatted datatype?