Re: using between with dates

[Thom Brown <thombrown@xxxxxxxxx>]

On 29 April 2010 14:55, Geoffrey Myers <geof@xxxxxxxxxxxxxxxxxxxxx> 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