Home > mailing lists

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

From	Karel Zak
Subject	Re: Problems with to_char(created, 'WW')
Date	October 24, 2002 10:08:12
Msg-id	20021024130811.D13536@zf.jcu.cz Whole thread Raw
In response to	Problems with to_char(created, 'WW') (Andreas Joseph Krogh <andreak@officenet.no>)
List	pgsql-sql

Tree view

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@zf.jcu.cz>http://home.zf.jcu.cz/~zakkr/C, PostgreSQL, PHP, WWW, http://docs.linux.cz,
http://mape.jcu.cz

pgsql-sql by date:

From: andres javier garcia garcia
Date: 24 October 2002, 09:57:53
Subject: ORDER the result of a query by date

From: Tomasz Myrta
Date: 24 October 2002, 10:13:03
Subject: Re: Problems with to_char(created, 'WW')

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

Previous

Next