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

[GENERAL] Extract giving wrong week of year

2015-09-25 Thread Ben Primrose
All, 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? Thanks Ben [bprimrose@primrose partitioning]$ psql Null display is "¤". Line style is unicode. Output format is wrapped. Tim