Hello,
I am using ODAC 9.7.26 on C++Builder 6.0 Professional Edition.
When I run a query on a table which has columns defined as TimeStamp(3) on SQLDeveloper those columns are shown with decimal values after the seconds, although the TField::AsDateTime property round the timestamp value to seconds.
I saw there is a AsTimeStamp property implemented by ODAC on version 9.5, but I am getting compiling errors when using TField::FieldByName("XXXX")->AsTimeStamp. How should I use it ?
Thank you very much.
Best regards.
Jayme Jeffman
Using AsTimeStamp
Re: Using AsTimeStamp
Try using the code below :
Code: Select all
TOraTimeStamp *XXXXValue;
XXXXValue = ((TOraTimeStampField *) (OraQuery->FieldByName("XXXX"))) -> AsTimeStamp;
Re: Using AsTimeStamp
Thank you very much for answering me.
This made the trick.
Best regards.
Jayme Jeffman
This made the trick.
Best regards.
Jayme Jeffman
Re: Using AsTimeStamp
We are glad to see the problem resolved. Please don't hesitate to contact us with questions concerning ODAC usage.