"Robert Sanford" <rsanford@xxxxxxxxx> writes: > It appears to me that there is some inconsistency in the date > calculations for my PostgreSQL install (version 8.0 on Win32). extract(DOW) follows the convention that the week starts on Sunday, but extract(WEEK) uses the ISO convention, which includes weeks starting on Monday. No, it's not super consistent, but hardly anything about date/time conventions is :-( regards, tom lane
