Forums | Admin

Discussion Forums: help

Start New Thread

Message: 97834 BY: Praveen Devarao (praveend) DATE: 2012-05-10 04:17 SUBJECT: RE: SQL Statement invalid (Rails,remote database)   Hi Stephan, >> Using timestamps in migration produce -415 Data conversion error << I am also facing this error. The reason this error is popping up is the datetime value informix is expecting should be of the format '2008-11-11 17:53:33.00000' where as Ruby's Time.now retunrs the timestamp as '2008-11-11 17:53:33' . The non availability of fraction part is causing the Data conversion error. I am checking this with the Informix team here to see what is the correct format and is there some setting that will automatically append the default fraction part if not specified. Once I clear up this error I will look into the others that you have reported. How critical is this for you. Could I buy some time for this? Thanks Praveen

Thread View

Thread Author Date SQL Statement invalid (Rails,remote database) Stephan Keller 2012-05-02 14:20       RE: SQL Statement invalid (Rails,remote database) Praveen Devarao 2012-05-02 17:35             RE: SQL Statement invalid (Rails,remote database) Stephan Keller 2012-05-02 19:32                   RE: SQL Statement invalid (Rails,remote database) Stephan Keller 2012-05-09 14:29                         RE: SQL Statement invalid (Rails,remote database) Praveen Devarao 2012-05-10 04:17                               RE: SQL Statement invalid (Rails,remote database) Stephan Keller 2012-05-10 05:21                                     RE: SQL Statement invalid (Rails,remote database) Praveen Devarao 2012-05-16 06:53                                           RE: SQL Statement invalid (Rails,remote database) Stephan Keller 2012-05-16 09:24                                                 RE: SQL Statement invalid (Rails,remote database) Praveen Devarao 2012-05-16 09:42