odd format for timestamp(0)

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

odd format for timestamp(0)

Post by jdorlon » Tue 19 Sep 2017 15:20

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
Devart Team
Posts: 1117
Joined: Mon 06 Jul 2015 11:34

Re: odd format for timestamp(0)

Post by MaximG » Wed 20 Sep 2017 09:44

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: 1117
Joined: Mon 06 Jul 2015 11:34

Re: odd format for timestamp(0)

Post by MaximG » Mon 11 Dec 2017 12:16

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
Posts: 119
Joined: Fri 05 Jan 2007 22:07

Re: odd format for timestamp(0)

Post by jdorlon » Fri 03 Aug 2018 17:51

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
Devart Team
Posts: 1117
Joined: Mon 06 Jul 2015 11:34

Re: odd format for timestamp(0)

Post by MaximG » Mon 06 Aug 2018 08:34

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
Posts: 119
Joined: Fri 05 Jan 2007 22:07

Re: odd format for timestamp(0)

Post by jdorlon » Mon 06 Aug 2018 12:13

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

Post Reply