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

In response to Geoffrey Myers :
> 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?

Sure, why not, but you have to CAST your STRING into a DATE, or you have
to use to_date().

test=*# select '04/30/2010'::date;
    date
------------
 2010-04-30
(1 row)


And yes, write "+ '14 days'::interval " instead of just only +14.


Regards, Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431  2EB0 389D 1DC2 3172 0C99