Re: BETWEEN not matching on timestamp value

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: BETWEEN not matching on timestamp value
Дата
Msg-id dcc563d10906301048k48e980f8jbdeff8b3379cab4b@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BETWEEN not matching on timestamp value  (Alban Hertroys <dalroi@solfertje.student.utwente.nl>)
Ответы Re: BETWEEN not matching on timestamp value  (johnf <jfabiani@yolo.com>)
Список pgsql-general
On Tue, Jun 30, 2009 at 11:45 AM, Alban
Hertroys<dalroi@solfertje.student.utwente.nl> wrote:
> 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!

You laugh, but who will be fixing the Y20M problem, huh?

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

Предыдущее
От: Alban Hertroys
Дата:
Сообщение: Re: BETWEEN not matching on timestamp value
Следующее
От: "James B. Byrne"
Дата:
Сообщение: Re: BETWEEN not matching on timestamp value