Re: using between with dates

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: using between with dates
Дата
Msg-id 201004290711.00868.adrian.klaver@gmail.com
обсуждение исходный текст
Ответ на using between with dates  (Geoffrey <lists@serioustechnology.com>)
Список 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.klaver@gmail.com

В списке pgsql-general по дате отправления:

Предыдущее
От: Geoffrey
Дата:
Сообщение: Re: using between with dates
Следующее
От: Tom Lane
Дата:
Сообщение: Re: using between with dates