var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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,
The effective_date column should be created as:
DATETIME year to fraction(3)
That solves that problem.