How to get more than 6 digits of precision on INTERVAL fields?

[jdorlon]

Hello,

If I create a table like below, with 9 digits of precision on an INTERVAL column, then select from it with a TSmartQuery, I only see 6 digits of precision in the result. Is this configurable?

Thanks
John Dorlon

Code: Select all

CREATE TABLE A_INTERVAL
( KEY_COL       NUMBER,
  INTERVAL_DTS  INTERVAL DAY(4) TO SECOND(9) default '+01 01:01:11.123456789'
);
insert into a_interval (key_col) values (1);
commit; 

[MaximG]

Thank you for the information. We have reproduced the issue and will investigate its origin. We will inform you about the results shortly.

[MaximG]

We've reproduced the issue and fixed it. The fix will be included in the new ODAC build, which we're planning to release next week.

[jdorlon]

Thank you Maxim.