Devart Forums

Hello,

I use ODAC 10.3.8 with Delphi 2009 and Oracle 11.2.0.2.0
Can I get date-type field values to string?

The return value of ODAC is as follows.

1. OraSession.Direct = False , Qry.FieldsAsString = False;

SQL>select sysdate from dual;
sysdate
------------------------
2019-01-06 오전 12:44:01

2. OraSession.Direct = False , Qry.FieldsAsString = True;

SQL>select sysdate from dual;
sysdate
------------------------
06-JAN-19


3. OraSession.Direct = True , Qry.FieldsAsString = False;

SQL>select sysdate from dual;
sysdate
------------------------
2019-01-06 오전 12:44:01

4. OraSession.Direct = False , Qry.FieldsAsString = True;

SQL>select sysdate from dual;
sysdate
------------------------
xw3

=> When Orasession.Option.Direct is True and Qry.FieldsAsString is True, sysdate valus was broken
There was no problem with previous versions. mayby 10.2.6 09

Best regards,
Benajmin Yang

Thank you for the information. We will investigate the described issue and let you know the results shortly.

We reproduced the issue and fixed this error. The required changes are included in the new ODAC build, which we plan to release next week.

I am always thankful for your hard work.

Please don't hesitate to contact us with questions concerning our product usage.