2009/9/29 Jeremy Evans <[email protected]>: > > On Sep 29, 9:36 am, André Allavena <[email protected]> wrote: >> Well, Oracle DB has a native type of data which really is a datetime. >> I'm trying to insert a date time. >> >> With the logger, >> inserting Time.now fails, it's inserting a timestamp. >> >> I, [2009-09-29T16:42:39.395419 #12644] INFO -- : INSERT INTO "T_TEST" >> ("F_ID", "F_DATE") VALUES (1, TIMESTAMP '2009-09-29 >> 16:42:39.395149+0100') >> stmt.c:539:in oci8lib.so: ORA-01874: time zone hour must be between >> -12 and 14 (OCIError) > > The error message is bogus since the time zone hour is obviously > +1. According to Oracle's documentation (according to > http://download.oracle.com/docs/cd/B19306_01/server.102/b14225/ch4datetime.htm), > the example timestamp literals have a space separating the time zone > from the time, and use a colon to separate the time zone hour from the > time zone minute. My guess is the missing colon in the timezone > offset is what is causing the problem, based on the error message. > Try the diff at http://pastie.org/635623 (untested, since I don't have > access to an Oracle database).
I tested it, it works like a charm. Your fast turn around time is very appreciated. Thanks a lot. PS: I tested it on the stable 3.4.0 branch as that's what I had installed, the sql.r file was a little different, but nothing of concern. PPS: the oracle binaries are available, they've got packages for Debian (10.2.0) or RPM (10 and 11 I think), in case you were interested. Not certain what licenses though. André --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en -~----------~----~----~----~------~----~------~--~---
