Can I get date-type field values to string?

[ysyang99]

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

[MaximG]

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

[MaximG]

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.

[ysyang99]

I am always thankful for your hard work.

[MaximG]

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