Devart Forums

Posted: **Mon 11 Mar 2019 20:15**

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;

Posted: **Tue 02 Apr 2019 05:10**

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

Posted: **Fri 19 Jul 2019 09:14**

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.

Posted: **Fri 19 Jul 2019 13:09**

Thank you Maxim.

Devart Forums

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

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

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

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

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