On Thu, Sep 26, 2002 at 11:55:48 -0400, Jean-Luc Lachance <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
