Lost resolution in TimeStamp column

Lost resolution in TimeStamp column

Postby areales » Thu 09 Jun 2016 09:53

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.
areales
 
Posts: 1
Joined: Thu 09 Jun 2016 09:34

Re: Lost resolution in TimeStamp column

Postby AlexP » Tue 14 Jun 2016 12:34

Please send a small sample demonstrating the issue with timestamp to support*devart*com , including scripts for creating and populating the table and storedprocedure.
AlexP
Devart Team
 
Posts: 5530
Joined: Tue 10 Aug 2010 11:35


Return to dbExpress driver for Oracle