Re: [GENERAL] day of week

2007-11-01 Thread Tomáš Vondra
Hi, I have records with date column. Is there a way I can get which day of week this date is? http://www.postgresql.org/docs/8.2/interactive/functions-datetime.html#FUNCTIONS-DATETIME-EXTRACT t.v. ---(end of broadcast)--- TIP 4: Have you search

Re: [GENERAL] day of week

2007-11-01 Thread A. Kretschmer
am Wed, dem 31.10.2007, um 16:34:44 +0200 mailte Anton Andreev folgendes: > Hi, > > I have records with date column. Is there a way I can get which day of > week this date is? Yes, no problem. select extract (dow from date). Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1

Re: [GENERAL] day of week

2007-11-01 Thread Thomas Kellerer
Anton Andreev wrote on 31.10.2007 15:34: Hi, I have records with date column. Is there a way I can get which day of week this date is? What about the extract() function with the dow parameter? Tho

Re: [GENERAL] day of week

2007-11-01 Thread Pavel Stehule
On 31/10/2007, Anton Andreev <[EMAIL PROTECTED]> wrote: > Hi, > > I have records with date column. Is there a way I can get which day of > week this date is? > > Cheers, > Anton Hello http://www.postgresql.org/docs/8.2/interactive/functions-datetime.html EXTRACT or function date_part Regards Pav

[GENERAL] day of week

2007-11-01 Thread Anton Andreev
Hi, I have records with date column. Is there a way I can get which day of week this date is? Cheers, Anton ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining

Re: [GENERAL] Day of week vs. Language

2007-07-11 Thread Peter Eisentraut
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

[GENERAL] Day of week vs. Language

2007-07-09 Thread Stefan Christ
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