Re: using between with dates

[Szymon Guz <mabewlun@xxxxxxxxx>]

2010/4/29 Geoffrey Myers <geof@xxxxxxxxxxxxxxxxxxxxx>

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