Postgres Pro
Downloads
Home   >   mailing lists

Thread: Day of week vs. Language

Day of week vs. Language

From
Stefan Christ
Date:
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

Re: Day of week vs. Language

From
Peter Eisentraut
Date:
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/