On 29 April 2010 14:55, Geoffrey Myers <geof(at)serioustechnology(dot)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