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). Jeremy --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
