Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004

    Question Unanswered: How to store 3 digit millisecond values

    When attempting to run the following SQL:

    INSERT INTO table_a (effective_date, priority) VALUES ('2005-10-04 00:00:00.000', 3)

    I get the following error message:

    ERROR CODE: -1264
    Extra characters at the end of a datetime or interval

    I have tried this with ifxjdbc.jar version 2.20 JC2, 2.21.JC6, and 3.00.JC2.

    I can get statement to run without an error if I run the following SQL

    INSERT INTO table_a (effective_date, priority) VALUES ('2005-10-04 00:00:00.0', 3)

    Removing the last two zeros in the millisecond range allows the statement to run.

    Any ideas on what else to check? Is this a server problem and not a driver problem? Does Informx allow 3 digit in the millisecond range?

    Thanks in advance,


  2. #2
    Join Date
    Sep 2002
    The effective_date column should be created as:
    DATETIME year to fraction(3)

  3. #3
    Join Date
    Feb 2004
    That solves that problem.



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts