Zeoslib Portal

Posted: **16.08.2011, 19:32**

Hello my friends,

I found a error when i execute a simple SQL statement in a TZQuery:

select current_timestamp from dual

The error is "invalid argument to time encode", i comment this line in code, and this pass correct.

It can be a propertie from ZConnection to Oracle? The ZeosLib work's fine in Oracle 10.g?

Thanks to all.

Posted: **16.08.2011, 20:58**

The error appers related to miliseconds convert, i do a convert in statement and now it's work, the question is how to correct the error to all users?

Code: Select all

select TO_TIMESTAMP(TO_CHAR(current_timestamp, 'DD-MM-YYYY HH24:MI:SS'), 'DD-MM-YYYY HH24:MI:SS') from dual

The inspiration to this correction is from this page, he makes the correction direct in code in of ZeosLib.

http://zeosbugs.firmos.at/view.php?id=116

Posted: **31.10.2011, 00:31**

Can you try to fix the TZOracleResultSet.GetAsDateTimeValue function to convert correctly without exceptions?

Mark

Zeoslib Portal

Erro ZeosLib 6.6.6., with Oracle 10g + Delphi 7

Erro ZeosLib 6.6.6., with Oracle 10g + Delphi 7