Re: start and end of the week

On Thu, Sep 26, 2002 at 11:55:48 -0400,
Jean-Luc Lachance <jllachan(at)nsd(dot)ca> wrote:
> How about:
>
> select now() - date_part( 'DOW', now()) as starts_on,
> now() -date_part( 'DOW', now()) + 6 as ends_on;

That won't work in 7.3.

The following works in both 7.2 and 7.3:
area=> select current_date - extract(dow from current_date)::int as start_date,
area-> current_date - extract(dow from current_date)::int + 6 as end_date;
start_date | end_date
------------+------------
2002-09-22 | 2002-09-28
(1 row)

Extract returns double precision and so needs a cast to int to work.