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'CA
"James B. Byrne" writes:
> 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_r
On Tue, Jun 30, 2009 at 11:45 AM, Alban
Hertroys 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: timesta
On Tue, June 30, 2009 13:24, Tom Lane wrote:
>
> No, it's complaining that the constant is out of range --- it's
> failing long before it's tried to do any actual BETWEEN comparisons.
> Surely you meant something more like 2008-08-09?
>
> regards, tom lane
>
The column is a
On Tue, Jun 30, 2009 at 11:51 AM, James B. Byrne wrote:
>
> On Tue, June 30, 2009 13:24, Tom Lane wrote:
>
>>
>> No, it's complaining that the constant is out of range --- it's
>> failing long before it's tried to do any actual BETWEEN comparisons.
>> Surely you meant something more like 2008-08-09
"James B. Byrne" writes:
> The column is a timestamp value. I expected any time on any given
> date to fall between the start and end of that day so the
> hh:mm:ss:hh portion does not leap out at me as something that should
> cause a problem. Should it?
It's the eight-digit year field that it'
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 "curre
On Tue, June 30, 2009 14:07, Tom Lane wrote:
>
>
> It's the eight-digit year field that it's unhappy with ...
>
Duuuh! I suppose that it would...
Thanks,
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte & Lyne Limit
On Tuesday 30 June 2009 10:48:50 am Scott Marlowe wrote:
> 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?
Not you or I that's for sure.
--
John Fabiani
--
Sent via pgsql-general