From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.

We appreciate your patience as we improve our online experience.

NI TestStand Idea Exchange

cancel
Showing results for 
Search instead for 
Did you mean: 
JV_Psi

Support milliseconds logging to SQL database column with datetime format.

Status: New

The suggestion is to support logging a datetime with millisecond accuracy to an sql database with an NI_DataOperation step.

I tried to implement this, but the milliseconds are not written to the database.

It would be very usefull to support this feature.

 

The datetime field in the sql database is defined as follows:

CREATE TABLE

dbo.UUT_RESULTS (

UUT_STARTTIME datetime NOT NULL

)

 

The datetime is logged to the database, but only up to the seconds, although the format string is defined as "mm-dd-yyyy hh:ii:ss.sss" and the string does contain the milliseconds e.g. "2-10-2016 11:49:15.505".

Software Details: TestStand  version 2010 SP1, Operating System:  Windows 7
 
 

3 Comments
RikWel
Member

I experience the same issue in TestStand 2017 SP1. Windows 10

Michael_Volk
Member

Same here, also Teststand 2017 and Windows 10..

RavensFan
Knight of NI

Well Michael.

 

If you have the same issue.  Then you should click the Kudo star to register your vote for the idea!