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,

jb

The effective_date column should be created as:
DATETIME year to fraction(3)

That solves that problem.

Thanks,

jb