Re: Problems with to_char(created, 'WW') - Mailing list pgsql-sql

From Tomasz Myrta
Subject Re: Problems with to_char(created, 'WW')
Date
Msg-id 3DB7D72E.1020700@klaster.net
Whole thread Raw
In response to Problems with to_char(created, 'WW')  (Andreas Joseph Krogh <andreak@officenet.no>)
List pgsql-sql
Uz.ytkownik Andreas Joseph Krogh napisa?:
> 
> Now - my question is, why is monday 21. in week 42, but tuesday 22. in week 
> 43?

Read the documentation - 4.7. Data Type Formatting Functions
"WW - week number of year (1-53) where first week start on the first day 
of the year"

Year 2002 started on Tuesday, so monday is still week 42, but tuesday is 
week 43.

Tomasz Myrta



pgsql-sql by date:

Previous
From: Karel Zak
Date:
Subject: Re: Problems with to_char(created, 'WW')
Next
From: Achilleus Mantzios
Date:
Subject: Re: ORDER the result of a query by date