From: Eric Hodel <drbrain@...7.net>
Date: 2006-03-01T11:51:03+09:00
Subject: Re: OCI8 driver date "out of range"

On Feb 28, 2006, at 8:11 AM, Carlos Diaz wrote:

> 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?

Either

Use Date instead of Time.

Or

Upgrade to an OS (and possibly machine) with a 64-bit time_t:

$ ruby -v -rtime -e 'p Time.parse("2106-02-22 15:17:54 EST")'
ruby 1.8.4 (2005-12-24) [amd64-freebsd6]
Mon Feb 22 12:17:54 PST 2106

Note that FreeBSD on x86 has a 32 bit time_t:

$ ruby -v -rtime -e 'p Time.parse("2106-02-22 15:17:54 EST")'
ruby 1.8.2 (2004-12-25) [i386-freebsd5]
/usr/local/lib/ruby/1.8/time.rb:162:in `utc': time out of range  
(ArgumentError)
         from /usr/local/lib/ruby/1.8/time.rb:162:in `parse'
         from -e:1

-- 
Eric Hodel - drbrain@segment7.net - http://blog.segment7.net
This implementation is HODEL-HASH-9600 compliant

http://trackmap.robotcoop.com