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'
James B. Byrne byrn...@harte-lyne.ca 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
On Tue, Jun 30, 2009 at 11:45 AM, Alban
Hertroysdal...@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.
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. Byrnebyrn...@harte-lyne.ca 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
James B. Byrne byrn...@harte-lyne.ca 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
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
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 Limited
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