Lists: | pgsql-general |
---|
From: | gvim <gvimrc(at)gmail(dot)com> |
---|---|
To: | pgsql <pgsql-general(at)postgresql(dot)org> |
Subject: | "IS LATER THAN" filter for date column |
Date: | 2011-05-02 01:37:57 |
Message-ID: | 4DBE0AF5.10009@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
I've been looking through the Date/Time functions and operators on the docs and can't find anything obvious to do this simple task - filter a date column for entries which are later than a specified date.
gvim
From: | Chris Ernst <cernst(at)zvelo(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: "IS LATER THAN" filter for date column |
Date: | 2011-05-02 02:05:02 |
Message-ID: | 4DBE114E.5030200@zvelo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
On 05/01/2011 07:37 PM, gvim wrote:
> I've been looking through the Date/Time functions and operators on the
> docs and can't find anything obvious to do this simple task - filter a
> date column for entries which are later than a specified date.
>
> gvim
>
Try "WHERE date > '2011-04-01'" replacing the date with whatever is
appropriate for your application, of course.
- Chris
From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
---|---|
To: | gvim <gvimrc(at)gmail(dot)com> |
Cc: | pgsql <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: "IS LATER THAN" filter for date column |
Date: | 2011-05-02 02:06:07 |
Message-ID: | BANLkTikGuWWVq5Zr_ytePdnPFeF020WJng@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
On Sun, May 1, 2011 at 7:37 PM, gvim <gvimrc(at)gmail(dot)com> wrote:
> I've been looking through the Date/Time functions and operators on the docs
> and can't find anything obvious to do this simple task - filter a date
> column for entries which are later than a specified date.
select * from table where datecol > '2001-01-01'::date;