Re: using between with dates

Tom Lane wrote:
> Geoffrey <lists(at)serioustechnology(dot)com> writes:
>> ship_date between '04/30/2010' AND '04/30/2010' + 14
>> ERROR: invalid input syntax for integer: "04/30/2010"
>
>> Can I use between with dates?
>
> The problem with that is the parser has no reason to treat the strings
> as dates, at least not till it comes to consider the BETWEEN
> comparisons, which is too late to help in resolving the addition
> in the subexpression (data types are determined bottom-up).
> This'd work:
>
> ship_date between '04/30/2010' AND '04/30/2010'::date + 14

Thanks muchly, likely a better solution then my timestamp approach.

--
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