Using AsTimeStamp

[jjeffman]

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

[MaximG]

Try using the code below :

Code: Select all

  TOraTimeStamp *XXXXValue;
  XXXXValue = ((TOraTimeStampField *) (OraQuery->FieldByName("XXXX"))) -> AsTimeStamp;

[jjeffman]

Thank you very much for answering me.

This made the trick.

Best regards.

Jayme Jeffman

[MaximG]

We are glad to see the problem resolved. Please don't hesitate to contact us with questions concerning ODAC usage.