Re: [BUGS] BUG #2977: dow doesn't conform to ISO-8601

2007-03-27 Thread Bruce Momjian
FYI, 8.3 will have an 'isodow' that conforms to ISO week start: test=> select current_date-2, date_part('dow', current_date-2), test->date_part('isodow', current_date-2); ?column? | date_part | date_part +---+--- 200

Re: [BUGS] BUG #2977: dow doesn't conform to ISO-8601

2007-02-07 Thread Peter Eisentraut
Am Mittwoch, 7. Februar 2007 11:24 schrieb Adriaan van Os: > Section 9.9.1 of the Postgres docs > > mentions that the "week" subfield of the date_part function conforms to the > ISO-8601 standard. I see no such claim there.

[BUGS] BUG #2977: dow doesn't conform to ISO-8601

2007-02-07 Thread Adriaan van Os
The following bug has been logged online: Bug reference: 2977 Logged by: Adriaan van Os Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: Mac OS X 10.4.6, intel Description:dow doesn't conform to ISO-8601 Details: Section 9.9.1 of the Post