OracleToDelphiTimestamp

[Ralf]

I have a table that contains a column TimeStamp.
When retrieving this table in a DOA dataset I get a conversion error. After some investigation it seems that the time is not converted correctly.

DD := EncodeDate(Year, Month, Day) + EncodeTime(Hour, Min, Sec, Round(FSec / 1000000));

In this piece of code 'Round(FSec / 1000000)'
results in 1000 which is not a valid argument for EncodeTime.

Is there something wrong with the value in my column or is this a DOA problem??

Thanks in advance

 

[Ralf]

BTW: The time-conversion happens in the DOA function:

OracleToDelphiTimestamp

 

[Ralf]

There are two values that result in this error. The values for fsec are:

999998000 and 999997000

 

[Marco Kalter]

This bug was fixed in 4.0.6. Which Direct Oracle Access version are you using?

 

[Ralf]

We're now using 4.0.5

Downloading 4.0.6 now.

Thanks!