On 29 April 2010 14:55, Geoffrey Myers <g...@serioustechnology.com> wrote:
> 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? > > You need to cast that last date, so: ship_date between '04/30/2010' AND '04/30/2010'::date + 14 Thom
