From: | Dmitry Tkach <dmitry(at)openratings(dot)com> |
---|---|
To: | Bruno Wolff III <bruno(at)wolff(dot)to> |
Subject: | Re: start and end of the week |
Date: | 2002-09-26 16:29:05 |
Message-ID: | 3D9335D1.4040807@openratings.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Does any one know what is the reason not to put this logic into date_trunc () function?
It seems to work with pretty much *any* unit imaginable, *except* for 'week'...
Dima
Bruno Wolff III wrote:
> 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.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jordan Reiter | 2002-09-26 17:51:33 | None |
Previous Message | Bruno Wolff III | 2002-09-26 16:20:29 | Re: start and end of the week |