2010/4/29 Geoffrey Myers <g...@serioustechnology.com> > I'm trying the following: > > ship_date between '04/30/2010' AND '04/30/2010' + 14 > > But this returns: > > ERROR: invalid input syntax for integer: "04/30/2010" > > Can I use between with dates? > > > This should be fine: ship_date between '04/30/2010'::date AND '04/30/2010'::date + 14
regards Szymon Guz