| From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Cc: | Geoffrey <lists(at)serioustechnology(dot)com> |
| Subject: | Re: using between with dates |
| Date: | 2010-04-29 14:11:00 |
| Message-ID: | 201004290711.00868.adrian.klaver@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thursday 29 April 2010 6:58:26 am Geoffrey 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?
>
> --
> 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
ship_date between '04/30/2010' AND '04/30/2010'::date + 14
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | sandeep prakash dhumale | 2010-04-29 14:14:10 | Re: Re: [GENERAL] [SQL] Tsearch not searching 'Y' |
| Previous Message | Geoffrey | 2010-04-29 14:09:31 | Re: using between with dates |