Re: Problems with to_char(created, 'WW')

From: Tomasz Myrta <jasiek(at)klaster(dot)net>
To: Andreas Joseph Krogh <andreak(at)officenet(dot)no>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Problems with to_char(created, 'WW')
Date: 2002-10-24 11:19:10
Message-ID: 3DB7D72E.1020700@klaster.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Achilleus Mantzios 2002-10-24 11:28:33 Re: ORDER the result of a query by date
Previous Message Karel Zak 2002-10-24 11:08:11 Re: Problems with to_char(created, 'WW')