Page 1 of 1

Lost resolution in TimeStamp column

Posted: Thu 09 Jun 2016 09:53
by areales
Hi,
At present we are working with “dbExpress Driver for Oracle”, version "4.20.1.11” in Delphi 2007 without any problems.
Today, I’m testing the same component but different version (6.8.12.0) in Delphi 10 and I have a problem.
I’m retrieving data form BBDD Oracle 11.2.0.4 executing a TSQLStoreProc and one of the columns is a Timestamp column. This column have a milliseconds in the BBDD but when I read the value from Delphi, the milliseconds (Fractions) always show 0(zero), other values are correct
I tried to read this column from Delphi like a “TimeStamp”, “String”, “DateTime” with the same result, the milliseconds return zero.

Summary:

-Work in Delphi 2007, driver version(dbxoda.dll) 4.20.1.11, Windows 7. Oracle client 10g R2
-It does not work in Delphi 10, driver version(dbxoda.dll) 6.8.12.0, Windows 10. . Oracle client 11g R1

Any idea?

Thanks in advance.

Re: Lost resolution in TimeStamp column

Posted: Tue 14 Jun 2016 12:34
by AlexP
Please send a small sample demonstrating the issue with timestamp to support*devart*com , including scripts for creating and populating the table and storedprocedure.