using between with dates - Mailing list pgsql-general

From Geoffrey
Subject using between with dates
Date
Msg-id 4BD99082.80803@serioustechnology.com
Whole thread Raw
Responses Re: using between with dates
Re: using between with dates
Re: using between with dates
List pgsql-general
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?

--
Until later, Geoffrey

"I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them."
- Thomas Jefferson

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Tsearch not searching 'Y'
Next
From: Geoffrey
Date:
Subject: Re: using between with dates