Postgres Pro
Downloads
Home   >   mailing lists

Day of week vs. Language - Mailing list pgsql-general

From Stefan Christ
Subject Day of week vs. Language
Date
Msg-id 1183713343.557137.161110@n2g2000hse.googlegroups.com
Whole thread Raw
Responses Re: Day of week vs. Language  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
Tree view 
Hello together,

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?

Thanks in advance,
Stefan

pgsql-general by date:

Previous
From: Rupesh Bajaj
Date:
Subject: Implementation of three new operators inside the PostgreSQL
Next
From: Lew
Date:
Subject: Re: CASE in ORDER BY clause