Re: BETWEEN not matching on timestamp value - Mailing list pgsql-general

On Jun 30, 2009, at 7:17 PM, James B. Byrne wrote:

> I have encountered an error that, on the face of it, seems to me to
> be inexplicable.  I hope that someone here can illuminate the matter
> for me.
>
>      PGError: ERROR:  timestamp out of range: "20080809-01-01
> 00:00:00"
>      : SELECT * FROM "currency_exchange_rates" WHERE
> (currency_code_base = E'CAD' AND currency_code_quote = E'JPY'
> AND effective_from BETWEEN '20080809-01-01 00:00:00' AND
> '20080809-01-01 23:59:59')  ORDER BY currency_code_base,
> currency_code_quote, effective_from DESC


Oh I so do hope that we won't have to bother with currencies anymore
THAT far into the future!

Alban Hertroys

--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.


!DSPAM:737,4a4a4f2d759151169695543!