Re: using between with dates

From: Szymon Guz <mabewlun(at)gmail(dot)com>
To: Geoffrey Myers <geof(at)serioustechnology(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: using between with dates
Date: 2010-04-29 14:50:42
Message-ID: i2ke4edc9361004290750l7553a58ax999f4e9b7211270c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2010/4/29 Geoffrey Myers <geof(at)serioustechnology(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2010-04-29 14:57:58 Re: using between with dates
Previous Message Thom Brown 2010-04-29 14:50:35 Re: using between with dates