Postgres Pro
Downloads
Home   >   mailing lists

Re: select to_char(current_timestamp, 'YYYY-WW'); - Mailing list pgsql-general

From Alexander Farber
Subject Re: select to_char(current_timestamp, 'YYYY-WW');
Date
Msg-id AANLkTim3XNiXyud4s-vWuZwFKRxZK0NhDk7Hw23QhpPS@mail.gmail.com
Whole thread Raw
In response to Re: select to_char(current_timestamp, 'YYYY-WW');  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: select to_char(current_timestamp, 'YYYY-WW');  (Alexander Farber <alexander.farber@gmail.com>)
List pgsql-general
Tree view 
On Fri, Nov 5, 2010 at 1:21 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> WW is defined as starting the first week on the first day of the year.
> 2010 started on a Friday so the week number increments on Fridays.
>
> There are some other format codes with different behavior ...

Thank you, that is what I thought

But is there a format code for a week starting on Sunday or Monday?

Sorry, I can't find it at
http://www.postgresql.org/docs/8.4/interactive/functions-formatting.html

Regards
Alex

pgsql-general by date:

Previous
From: "Carlo Stonebanks"
Date:
Subject: How do you control IMMUTABLE PG PROC results?
Next
From: Alexander Farber
Date:
Subject: Re: select to_char(current_timestamp, 'YYYY-WW');