From: | Lukasz Brodziak <lukasz(dot)brodziak(at)gmail(dot)com> |
---|---|
To: | richard terry <rterry(at)pacific(dot)net(dot)au> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Date help |
Date: | 2010-10-05 06:04:22 |
Message-ID: | AANLkTimdzaL6jFizzGQhjQp+BOCtmLAud3t=4Db+BN3B@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
There is another way but it might affect the performance: WHERE
<date_field> BETWEEN <past_date> AND Now() / CURRENT_DATE;
2010/10/5 richard terry <rterry(at)pacific(dot)net(dot)au>:
> On Tuesday 05 October 2010 13:49:41 Garrett Murphy wrote:
>> WHERE date_field>=(CURRENT_DATE-INTERVAL '1 month')
>>
> thanks for the suggestion, I'll take a look tonight about this and get back to
> the list.
>
> richard
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>
--
Łukasz Brodziak
II MU Bioinformatyka
From | Date | Subject | |
---|---|---|---|
Next Message | Mladen Gogala | 2010-10-05 12:30:38 | Re: Incremental Backup |
Previous Message | richard terry | 2010-10-05 04:01:21 | Re: Date help |