odd format for timestamp(0)

[jdorlon]

set up:

Code: Select all

create table ts_test (col1 timestamp(0));
insert into ts_test select systimestamp from dual;
commit;

now, if put in a TSmartQuery: Select * from ts_test, the output of the timestamp column looks like:

9/19/2017 3:19:21. PM

notice the dot after the seconds. Can this be removed?

[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 have already fixed the error, and the fix will be included in the next build. We plan to release the build the near future.

[jdorlon]

Hello,

I saw in the release notes for 10.1.4 that this was fixed, but for me, the problem persists in 10.2.6. Can you check this again please? Is there something that I need to do to not see the dot?

Thank you,

-John

[MaximG]

We tested the work of ODAC 10.2.6 (09-Jul-18) according to your description and found no problems. It's true, the described change is included in 10.1.4 (18-Jan-18). Please make sure that the obsolete versions of libraries related to ODAC are absent in your environment. Perhaps this will require installing ODAC 10.2.6 again

[jdorlon]

I don't know what the problem was, but it is working this morning. Thanks.