Re: [GENERAL] Extract giving wrong week of year

2015-09-28 Thread Ben Primrose
5:01 PM To: Ben Primrose Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Extract giving wrong week of year Ben Primrose writes: > I’m seeing some odd behavior from the extract function. > Any idea why extract would think January 3rd of next year is the 53rd > wee

Re: [GENERAL] Extract giving wrong week of year

2015-09-25 Thread Tom Lane
Ben Primrose writes: > I’m seeing some odd behavior from the extract function. > Any idea why extract would think January 3rd of next year is the 53rd week > of the year? See the fine manual ... http://www.postgresql.org/docs/9.3/static/functions-datetime.html#FUNCTIONS-DATETIME