Postgres Pro
Downloads
Home   >   mailing lists

Re: using between with dates - Mailing list pgsql-general

From Szymon Guz
Subject Re: using between with dates
Date
Msg-id i2ke4edc9361004290750l7553a58ax999f4e9b7211270c@mail.gmail.com
Whole thread Raw
In response to using between with dates  (Geoffrey Myers <geof@serioustechnology.com>)
List pgsql-general
Tree view


2010/4/29 Geoffrey Myers <geof@serioustechnology.com>
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
 

pgsql-general by date:

Previous
From: Geoffrey Myers
Date:
Subject: using between with dates
Next
From: Thom Brown
Date:
Subject: Re: using between with dates