From: Carlos Diaz <crdiaz324@...>
Date: 2006-03-01T12:05:31+09:00
Subject: Re: OCI8 driver date "out of range"

Ok, after doing some research on this, it looks like the problem isn't
with OCI8 but it appears to be more directly related to a conversion
problem.  Specifically when oci8.rb tries to covert the Oracle Date
into Time.local.  This is because Time relies on seconds since 1970
and I think the 32 bit operating system does not have enough room to
store a date with that many seconds since 1970 (please correct me if
I'm wrong).  For example, if I go to irb and type:  Time.local(2106,
02, 22, 15, 17, 54), that should produce th date below, but it
actually give me a ArgumentError:  time out of range.

Has anyone else found a way to work around this problem?  I found the
following link where Kirk Haines seemed to think this was not a
difficult fix.  Just don't know if anyone has gotten around to writing
it:

http://groups.google.com/group/comp.lang.ruby/browse_thread/thread/1ac3f69bfabb8357

Any help would be greatly appreciated.

Thanks,
Carlos

On 2/28/06, Carlos Diaz <crdiaz324@gmail.com> wrote:
> Hi all,
>
> I am building an applications that access an existing database that
> has dates in the future...as far ahead as 2106.  However, when I try
> to access the data in those columns (I'm using the OCI8 driver), I get
> the following error:
>
> RangeError in Tools#search
>
> out of range of Time (expect between 1970-01-01 00:00:00 UTC and
> 2037-12-31 23:59:59, but 2106-02-22 15:17:54 EST)
>
> Anyone familiar with this?  How can I resolve?
>
>