Table valued parameters TDateTime field trim milisec

[Calkins]

Hi.

In our version 6.6 when we pass TDateTime field (format 'YYYY-MM-DD hh:nn:ss.zzz') in TMSTableData it sends DateTime without miliseconds to database (checked in profiler).

Code: Select all

TMSStoredProc *mssp;
TMSTableData *mst;

 mst->Open();
 mst->Append();
 mst->FieldByName("BeginDate")->AsDateTime = TDateTime(2013,9,12,10,31,50,440);
 mst->Post();
 mssp->ParamByName("EventsComment")->AsTable = mst->Table;
 mssp->Execute();
 mst->Close();

Code above sends only 2013-09-12 10:31:50 without 440 miliseconds.

It is an bug or we did something wrong?

Thx in advance for help.
Damian

[AndreyZ]

Hello,

Thank you for the information. We have reproduced the problem and the investigation of the problem is in progress. We will notify you when we have any results.

[Calkins]

Hi.

Any news about this bug?

[AndreyZ]

We are investigating this problem. As soon as we have any results we will let you know.

[AndreyZ]

We have fixed this problem. This fix will be included in the next SDAC build.

[Calkins]

Thx for your support.

[AndreyZ]

This problem is fixed in SDAC 6.8.15. It is already available for download.