Thread: [BUGS] BUG #14527: Calandar Week

The following bug has been logged on the website:

Bug reference:      14527
Logged by:          John Cantin
Email address:      jcantin@strategicfuse.com
PostgreSQL version: 9.3.6
Operating system:   centos 7
Description:

Postgres seems to define calendar week differently depending on the function
called.

The extract function shows '2017-1-1' as week 52 but the to_char function
shows it as 1

select extract('week' from '2017-1-1'::date) as week

select to_char('2017-1-1'::date,'ww')


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

jcantin@strategicfuse.com writes:
> Postgres seems to define calendar week differently depending on the function
> called.

Yup, there's the "ISO 8601" way of counting weeks and the not-so-ISO way.
Read the manual carefully.

(The great thing about standards is there are so many to choose from.)

            regards, tom lane


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs