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

From: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
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:08:11
Message-ID: 20021024130811.D13536@zf.jcu.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Thu, Oct 24, 2002 at 12:51:35PM +0200, Andreas Joseph Krogh wrote:
>
> janerik=# select created, to_char(created, 'WW') as week from session WHERE
> username IS NULL ORDER BY week;

Please, see docs and 'IW' (ISO week).

Karel

--
Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
http://home.zf.jcu.cz/~zakkr/

C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tomasz Myrta 2002-10-24 11:19:10 Re: Problems with to_char(created, 'WW')
Previous Message Henshall, Stuart - Design & Print 2002-10-24 10:59:26 Re: ORDER the result of a query by date