Page 1 of 1
odd format for timestamp(0)
Posted: Tue 19 Sep 2017 15:20
by 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?
Re: odd format for timestamp(0)
Posted: Wed 20 Sep 2017 09:44
by MaximG
Thank you for the information. We have reproduced the issue and will investigate its origin. We will inform you about the results shortly.
Re: odd format for timestamp(0)
Posted: Mon 11 Dec 2017 12:16
by 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.
Re: odd format for timestamp(0)
Posted: Fri 03 Aug 2018 17:51
by 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
Re: odd format for timestamp(0)
Posted: Mon 06 Aug 2018 08:34
by 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
Re: odd format for timestamp(0)
Posted: Mon 06 Aug 2018 12:13
by jdorlon
I don't know what the problem was, but it is working this morning. Thanks.