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
Can I get date-type field values to string?
Re: Can I get date-type field values to string?
Thank you for the information. We will investigate the described issue and let you know the results shortly.
Re: Can I get date-type field values to string?
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.
Re: Can I get date-type field values to string?
I am always thankful for your hard work.
Re: Can I get date-type field values to string?
Please don't hesitate to contact us with questions concerning our product usage.