Thread: "IS LATER THAN" filter for date column
I've been looking through the Date/Time functions and operators on the docs and can't find anything obvious to do this simpletask - filter a date column for entries which are later than a specified date. gvim
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
On Sun, May 1, 2011 at 7:37 PM, gvim <gvimrc@gmail.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;