Re: Day of week vs. Language

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Cc: Stefan Christ <root(dot)bash(at)web(dot)de>
Subject: Re: Day of week vs. Language
Date: 2007-07-11 12:06:53
Message-ID: 200707111406.54040.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Am Freitag, 6. Juli 2007 11:15 schrieb Stefan Christ:
> the documentation of PGSQL 8.0 tells me, that extract(dow ...) will
> return 0 for Sundays. I know that this behaviour depends on the
> language settings on MSSQL, so that I have to correct this settings
> with an offset. What is the behaviour in PGSQL? Does the dow result
> also depend on the language settings, or will the value 0 ALWAYS be a
> Sunday?

It's always that way for this particular function.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Zlatko Matic 2007-07-11 12:15:02 odbc parameters
Previous Message Tom Allison 2007-07-11 10:24:35 Re: Duplicate Unique Key constraint error