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

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
jdorlon
Posts: 139
Joined: Fri 05 Jan 2007 22:07

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

Post by jdorlon » 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; 

MaximG
Devart Team
Posts: 1486
Joined: Mon 06 Jul 2015 11:34

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

Post by MaximG » 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.

MaximG
Devart Team
Posts: 1486
Joined: Mon 06 Jul 2015 11:34

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

Post by MaximG » 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.

jdorlon
Posts: 139
Joined: Fri 05 Jan 2007 22:07

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

Post by jdorlon » Fri 19 Jul 2019 13:09

Thank you Maxim.

Post Reply