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;